Selecting column within a selection
I would like to select a column within a selection.
For instance if the original selection is A1:D10
I would like to select D1:D10 and then manipulate the data.
I have tried many ideas but none seem to work.
For instance why doesn't the following select the first cell in the
last column of the selection. It selects a cell outside the selection
entirely.
Selection(Cells(1, Selection.Columns.Count)).Select
In addition, isn't the selection the range itself?
Msgbox selection.address
gives the correct address of the original selection.
Thanks for any help.
Don
|