View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred Holmes Fred Holmes is offline
external usenet poster
 
Posts: 112
Default Selecting more than one cell/colum with an offset statement?

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