View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
trammy trammy is offline
external usenet poster
 
Posts: 4
Default 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