| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to select a range of cells following an offset?
MS Office (Excel) running on XP Pro:
I am wanting to select a range consisting of the six cells following the one arrived at by: ActiveCell.Offset(0,1) in the same row. The row number would be different each time the offset is run. I would then copy the data in these six cells. Can anyone assist? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using offset to select a range | Excel Programming | |||
| Help in using an Offset in a .Range().Select | Excel Programming | |||
| Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming | |||
| Select Range - using Offset ( 40 ,0 ) - not working | Excel Programming | |||
| Select and Copy Range using Offset | Excel Programming | |||
![Wes_A[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
