Hi,

You can assign a cell (i.e. A1) in each sheet and count the sheet rows that
have data in that cell and then link your macro to that cell i have formula
for to be able to count dynamic the cells if they are not blank i don't know
if it works for you but if you want to use it you have to be care full that
don't leave blank rows between your data. the formula is:
=COUNTA(OFFSET($A$2,0,0,9999,1)).

Thanks,
--
Farhad Hodjat


"Eggtavius" wrote:

I have a large multi-tabbed workbook that we use as an Estimating tool.

Each worksheet contains many categories with various parts and pricing under
each category.

We use buttons and macros to hide and reveal the parts under each category.

Whenever we need to add a new category or additional parts to an existing
category (i.e. add in additional rows), the hide and reveal macros need to be
manually updated with the new row numbers - very time consuming!

Is there an easier way?