| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative Ranges - Multiple Cells
I would like to select a range of cells from column A - column L, but
everytime I run the loop the starting row reference and the number of rows will be different. I've worked out a solution, but it will only work if I can get a relative range to select multiple cells... something like this: Range("A" & myMarks(k)).Activate ActiveCell.Offset(0,0:Group, 11).Select But it doesn't work... is there anything that will do the same job? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter value zero into all cells in multiple ranges? | Excel Discussion (Misc queries) | |||
| Counting Criteria in Cells in Multiple Ranges | Excel Worksheet Functions | |||
| Add and Subtract ranges (with multiple cells) in vba | Excel Programming | |||
| changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
| select ranges of cells relative to location and then paste | Excel Programming | |||
Threaded Mode
