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

  • Thread starter Thread starter Rikin
  • Start date Start date
R

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
 
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
 
Back
Top