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