I have created a macro for a friend. Here are the specs:

The wkrbook has 36 pages. Each page tracks 5 depart accounting entrie
on the same page. (each page is for the day of the month entry fo
each department) The information is then summaries for each departmen
on a summary sheet. The format of each page is exactly the same.

Macro:
I wrote a relative macro to work on each worksheet in the wrkbook b
using the active sheet rather than a sheet name and used range names t
identify each of the departments on the worksheet. The range names ar
the same on each sheet.

Problem:
The macro was working but now it crashes on the range names and th
sheet name. I get an error 9. Can anyone tell me if this was th
incorrect approach or how to error proof the macro.

ps...I would have personally used access to achieve this goal

--
Message posted from http://www.ExcelForum.com