Cells(r,c) or ???

  • Thread starter Thread starter dhstein
  • Start date Start date
D

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.
 
sub copy_it()

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

end sub
 
Back
Top