Copy from here to there

[Francis Hookam]

Text in (say) A1

Want to copy into (say) B10

How?

Cells(1, 1). Copy Destination:= Cells(10, 2)

or something like that

Would prefer to keep to Cells(x, y) (rather that absolute references) since
I need to use variables

Cannot see why I cannot make it work!

Francis Hookham

 

[JE McGimpsey]

Text in (say) A1

Want to copy into (say) B10

How?

Cells(1, 1). Copy Destination:= Cells(10, 2)

or something like that

Would prefer to keep to Cells(x, y) (rather that absolute references) since
I need to use variables

Cannot see why I cannot make it work!

Eliminate the space:

Cells(1, 1).Copy Destination:=Cells(10, 2)


If you just want to copy the value, you can avoid the Copy altogether:

Cells(10, 2).Value = Cells(1, 1).Value

 

[Francis Hookam]

Thanks - just a space and Bingo! I knew I was close but just could not see
it

FH

Text in (say) A1

Want to copy into (say) B10

How?

Cells(1, 1). Copy Destination:= Cells(10, 2)

or something like that

Would prefer to keep to Cells(x, y) (rather that absolute references) since
I need to use variables

Cannot see why I cannot make it work!

Eliminate the space:

Cells(1, 1).Copy Destination:=Cells(10, 2)


If you just want to copy the value, you can avoid the Copy altogether:

Cells(10, 2).Value = Cells(1, 1).Value