Hi everyone! This is my first posting.
I recently bought Excel 2003 VBA.
I'm brand new to VBA

I've written my own User-Defined Functions and they work great BUT
they only work once.

I have two worksheets.
Sheet A has a list of info.
Sheet B counts the number of rows depending on the info in the rows.

If a new row is added or changed in Sheet A, the UDF in Sheet B doesn't reflect the change UNLESS I go into the cell in Sheet B where the UDF is and click inside it and hit <RETURN> Then it reflects the changes in Sheet A.

How do I get the UDF in Sheet B to recalculate?

Thanks in advance!

K. Moran

K Moran

Normally UDFs only recalculate when linked cells change or if forced with the F9 key.

Make this the first line of your UDF to calculate whenever the sheet recalculates :-

-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.