Need a little macro morsel


Posted by DanA on November 19, 2001 10:18 AM

Can someone help me out with code that will select a range of columns. The beginning column will be the column where the active cell is located in when the macro begins. The ending column will always be column "O" (the letter). Hope that makes sense. TIA.



Posted by CMorrigu on November 19, 2001 11:32 AM

Here's how to select the active column

Columns(ActiveCell.Column).SelectShadow Source