| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells(r,c) or ???
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells(r,c) or ???
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells(r,c) or ???
Thank you
"muddan madhu" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Linear Mode
