PDA

View Full Version : Solved: Macro Problem - Hanging



Pete
06-14-2008, 08:25 AM
Hi

Got a slight problem with the macro button "Update Validation Tables" Worksheet "Deal Selection"......

When you click the button to update tables.......takes for every....should complete the task in about 10 second....

The code for the macro is in module 6.......been looking at the problem for three hours cannot see the mistake..

see file zipped file attached

lucas
06-14-2008, 08:34 AM
Do you mean "update Allocation Tables"?

There are 11 macro's in module 6

Norie
06-14-2008, 10:35 AM
Pete

That button calls 10 different subs.:eek:

And a lot of those subs contain selecting and or loops.

Why do you think it should only take 10 seconds?:confused:

If the code is hanging I suggest you try investigating why by using the various debug facilities available in VBA. eg breakpoints, stepping through with F8 etc

Pete
06-14-2008, 11:32 AM
Do you mean "update Allocation Tables"? - yes

lucas
06-14-2008, 11:39 AM
so which of the 11 subs does the update allocation tables run?

Pete
06-14-2008, 11:44 AM
ALL of them.............i am still look at it might...i say might have found the solutionnn

Pete
06-14-2008, 11:50 AM
Thanks for the feedback fixed the problem

Norie
06-15-2008, 06:51 AM
Care to share?:)

Pete
06-15-2008, 07:04 AM
yes... i'll post he code here........once i figure out the current open question so i can add it in too....