Thread: Range Selection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Range Selection

why are you selecting in the first place. Tell us what you are trying to do
and we can suggest a better way.

--
Don Guillett
SalesAid Software

"Steve C" wrote in message
...
I have written code that results in a range of cells being selected in one
column. (Each time the code is run, it selects a different range of
varying
sizes, depending on what it is searching for). Once the range is
selected,
I would then like to offset that selection by 3 columns and select the
same
size range in that other column, plus the same size range in the column
immediately to the right of that one.

For example, let's say my code ends up selecting the range A10:A20. I
then
want my code to offset that selection to D10:E20. Does that make sense?
Thanks for your help!