Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The vba statement:
ActiveCell.Offset(0, 3).EntireColumn.Select Works just fine to select the third column to the right of the active cell. Is there a nice, clean, simple statement that would select the third and fourth columns to the right, something like: ActiveCell.Offset(0, 3:4).EntireColumn.Select which doesn't work. I'm basically trying to program a "column move" macro that prompts for the column(s) to move, and how many column(s) to the right/left to move it, and then performs the move. Is there one of those already out there to copy? Thanks, Fred Holmes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum and Offset: to add from a point to the last entry in the colum | Excel Worksheet Functions | |||
Selecting offset cells | Excel Discussion (Misc queries) | |||
Selecting a range offset from a cell | Excel Programming | |||
Combing an if then statement and an offset cell? | Excel Programming | |||
Selecting cell using range.offset | Excel Programming |