copy a string from worksheet1 at row a, column a to worksheet2 row a, column a

[trammy]

Hello,

I would like to get some helps here:

Dim rSource As Range
Dim rDest As Range

I want to copy a string from rSource at row a and column a to rDest row
a and column a. With this, when a cell in the rSource is empty, it
creates an empty cell in th rDest.

I can do: rDest.Value = sSource.Value
but I cannot do rDest.row = sSource.row (read only property).

Thanks,

Tammy

 

[Brian Taylor]

cells(rDest.row,rDest.column).value =
cells(sSource.row,sSource.column).value