hi there. I was wondering if somebody could help with the following problem I have.

I have x amount of reports (say 10 for example).Each report has 20 tabs. I want to scan these in using Adobe. But I need to reset the margins differently to a predefined specification for each tab.

Instead of me doing this individually for all the 20 tabs on 10 reports, is it possible to have a macro to do this?

The tabs are the same in each spreadsheet, but the number of lines going downwards may vary, but horizontally it will always be the same.

Any help would be appreciated.

Thanks