| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveCell.Row noncontiguous
I am using the ActiveCell.Row to copy and paste cell content.
Range("K" & ActiveCell.Row & ":" & "M" & ActiveCell.Row).Copy It allows the user to perform certain functions without being concerned about which columns to select. Many times they will be selecting multiple rows. Is there a modification to this routine that allows for the selection of multiple or noncontiguous rows? Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to add more that 30 noncontiguous cells in Excel | Excel Worksheet Functions | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format | Excel Programming | |||
| Noncontiguous rows | Excel Discussion (Misc queries) | |||
| noncontiguous cells | Excel Discussion (Misc queries) | |||
Threaded Mode
