"Selection" Code???

[elayem]

Hi,
In my maco I current have a certain set of numbers selected. Is ther
any code to expand the selection to the cells in the two columns to th
left of this selection? i.e. if cells C1 to H4 were filled, but want A
to H4 selected, is this possible? Also, this was just an example,
don't want the code to specifically use these cells, just in genera
how to select the two columns that exist in front of my selection
Thanks

 

[Ron de Bruin]

Hi elayem

You can try this

Selection.Offset(, -2).Resize(, Selection.Columns.Count + 2).Select