Hi I am a bit stumped and cannot see where I am going wrong. The detail is as follows......
The code below works fine apart for the 5th line in the code If Range("c21") = 0 Then...
In the worksheet Range C21 value is currently 2 but the macro just exits when I run the full routine and it gets to line 5 when I need it proceed to the printing stage.
Hoping someone can spot my error????
Please Login or Register to view this content.
Last edited by hans302; 03-16-2018 at 12:51 PM.
It helps to indent the code to see the nested hierarchy.
Is your Value in P29 > 0 ? If not, the code exits.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
That's great - I've added another line of code that picks up if P29 = 0 then it will jump over 5 lines of code using another GOTO function.
Seems to work OK now
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks