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


bj wrote:
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.

"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