I have a workbook with four worksheets are formatted in exactly the same way. They all have 12 blocks (one per month) of data plus a summary at the top of the page.

In Column A are some simple identifiers which are the same in each block.

So if I want to go to Find D&C in May I can select Find D&C and click it five times plus one for the Summary at the top.

I have written a macro which works fine but I was trying to expand part of it so that the Activecell on each of the four worksheets was the same but when I expand to include an array it doesn't like this bit 
Please Login or Register  to view this content.
This is a small part of the macro.

All help much appreciated.

Please Login or Register  to view this content.