Help! sub that calls other subs not working, if individually run they work!

Vassilisr

New Member
Joined
Nov 18, 2014
Messages
6
Hello everyone

would really need some advise with a weird thing going on

I have written some 12 subs, all needed to process a dataset. each one takes it from where the previous one leaves it.
when i run them individually and with the right order all work fine

when I ran the general Sub, which includes basically 12 Calls (the subs mentioned above) it doesn't process the data correctly. the problem is the 4th code. If I run individually and after it finishes continue with the rest, all is good

things that could be useful to know is that
i have not defined any general variants, all are defined inside their respective subs
At start, I use a prompt window to make the user enter specific info required
I have placed all codes at one simple module

sorry for not sending the code, but it would not be useful as it is really huge (2,000 lines)

thank you!
 
If you add:
Code:
Msgbox Lrow
after this line:
Code:
LRow = Cells(Rows.Count, 1).End(xlUp).Row
what does it show when running the routine, not stepping through.
 
Upvote 0

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,215,340
Messages
6,124,382
Members
449,155
Latest member
ravioli44

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top