select cells around activecell

[k1dr0ck]

Hi,

how do i select the cells around an activecell including the activecell using a macro?

2 cells up from the activecell
9 cells to the left from the activecell
2 cells to the right from the activecell
16 cells down from the activecell

For example activecell is J11 so the cells selected would be from A9 to L27

[Keebellah]

I just typed it in, not tested, but this would be the idea

Please Login or Register  to view this content.

[excelfandoo]

Please see if the below code works:

Please Login or Register  to view this content.

[:) Sixthsense :)]

Or

Please Login or Register  to view this content.

[k1dr0ck]

all of your code works, thanks guys!