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

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

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

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

Yes

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

Mike

"Rikin" wrote:

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

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

On 15 dic, 16:32, Mike H wrote:
Is it possible to fill in *a cell with text without having to copying it
from
another workbook.

Yes

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

Mike

"Rikin" wrote:
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