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.

My View wrote:

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

--

Dave Peterson