Hi All,

This may be a request too far and I'll understand if I'm chucked out of the forum, so forgive me in advance.

I am not a programmer, and have very basic knowledge of Word VBA - none of Excel VBA, and have taken over a role which involves using a macro created by my predecessor. Up to now it has worked perfectly; however, the goalposts have been moved and I'm struggling to sort out the problem.

The macro produces sheets (in Excel) which contain columns and rows detailing page numbers ranging from 1 to 150. Each page can be color or black and white and a short description of what will appear on that page when printed is included.

I now need the maximum range to be increased to 200 but get a "subscript out of range: error 9" when I input a figure above 161.

In the VBA, it states "SHEET (150,20)" and I presumed I simply changed 150 to 200 but that didn't work, and the macro fell over.

If anyone feels they may be able to advise, please let me know what I need to send/attach for your info.

Many thanks in advance whatever you guys decide.

Regards - Ron