sub copy_it()

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

end sub





On Jul 18, 11:05*pm, dhstein
wrote:
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.