Filter code skipping a line

Hi All,

Apologies for the vague title, but I currently have a problem where a routine is called from a cmb, but it misses the first line. If I go into the VBA project and run it from there the line is not skipped. I will include the code from the cmb.
cmb code:

Please Login or Register  to view this content.

Update_All code

Please Login or Register  to view this content.

and the FH to Cal code whree the problem lies.

Please Login or Register  to view this content.

The problem is that the figure on row 3 that should be updated with the above formula is not, but as I said if I run it from the project it works.

Any ideas??

JD

Roy,

Solved the problem by re-ordering the Update_All code. For some reason the last one one, APUHrstocal was reformatting the cells with its calculation. very wierd. This is now run first and the prolem has dissappeared.

The reason behind hiding the sheet hiding is that I could not stop excel going to sheet 1 when the code was being run and then coming back to sheet 2. I want sheet 2 to remain as the active sheet, but the code to still run on sheet 1. I guess my lack of knowledge with selecting sheets has forced me down this route. As for the users, it does not matter if they already have sheet 1 open, but as it is it closes it for them.

JD