copy a string from worksheet1 at row a, column a to worksheet2 row a, column a
Hello,
I would like to get some helps he
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
|