Cells(r,c) or ???

[dhstein]

I want to copy cells from one row to another using the row number and column
number of both source and destination. Example: copy FROM row 10 column 20
through row 10 column 30 TO row 100 column 50. Can anyone provide the
syntax for that? Thanks for any help on this.

 

[muddan madhu]

sub copy_it()

Range(Cells(10, 20), Cells(10, 30)).Select
Selection.FillRight
Cells(10, 30).Copy Cells(100, 50)

end sub

 

[dhstein]

Thank you

sub copy_it()

Range(Cells(10, 20), Cells(10, 30)).Select
Selection.FillRight
Cells(10, 30).Copy Cells(100, 50)

end sub