how do I fill in a cell with text in Excel macro (2003)

[Rikin]

Hi,

I am running a macro where I copy and paste values from workbook to another.
Is it possible to fill in a cell with text without having to copying it from
another workbook.

Kind regards,
Rikin

 

[Mike H]

Is it possible to fill in a cell with text without having to copying it
from

another workbook.

Yes

Range("A1").value="Sometext"

Mike

 

[Benito Merino]

Hello.

One way is:


Sub prueba()
Sheets("Hoja2").Range("C2").Resize(Sheets("Hoja1").Range
("A1").CurrentRegion.Rows.Count, Sheets("Hoja1").Range
("A1").CurrentRegion.Columns.Count).Value = Sheets("Hoja1").Range
("A1").CurrentRegion.Value
End Sub

Regards,

Benito
Barcelona