Select second columns only

[My View]

I want to select every second column between certain rows but I don't want
to do "A4:A20, C4:C20, E4:E20, G4:G20 ..... etc etc".

Is there a more efficient way to show this?

regards

PeterH

 

[Guest]

What do you want to do with the data.
If you need it to go to someplace else using something like
=indirect("R"&row()-20&"C"&Column()*2-1)
in A24:E40 would group the data in your example.

 

[Dave Peterson]

You could select that discontiguous range once, then give it a nice range name.
(Insert|Name|define)

Then if you ever need to select it again, you can just:

Edit|goto (or F5 or ctrl-g), type in that name and hit enter

(or even just type the name in the namebox (to the left of the formula bar) and
hit enter.)

But you'd still have to do it at least once.

 

[pshardie]

Thanks for the reply.
I want to impose conditions on those cells by way of a macro. So the
cells will be listed in the macro. They will not be listed in a formula
in the cell(s).
PeterH