Excel 2007 : Multiple offsets of a range.

[qcity]

Hey all. Is there a way to get this code to work?

Please Login or Register  to view this content.

It's meant to select the offset of A1 from A1 to A2 if the variable SADOffsetCount is equal to 0, and it increases when the value increases.

[qcity]

Sorry for repost.

Please Login or Register  to view this content.

This what I've got so far. But what if I want to select the following?:

Please Login or Register  to view this content.

?

[romperstomper]

It would just be:

Please Login or Register  to view this content.

since it's one solid block of cells.

Note: I have added code tags to both your posts. Please learn to use them when posting code.

[qcity]

I guess when it's inputted in VBA, it's very different from typing it in a cell. In a cell, that gave me 2 different cell inputs. Thanks a lot. Solved.