I get a "Next Without For" runtime error for this code. Can anyone help me find out what's wrong?
Please Login or Register to view this content.
I get a "Next Without For" runtime error for this code. Can anyone help me find out what's wrong?
Please Login or Register to view this content.
The reason we write code with different line indentations is to make it easier to see at a glance what code is contained in, for example, an IF THEN statement, or a FOR NEXT loop, etc. Your code indentations don't even slightly match what's going on, which is why you're having trouble spotting what you've done.
Firstly, re-indent your code (i'm sure that's not the right word but it's been a long day), then it'll be easy to spot the NEXT you've put behind an IF THEN that's not being recognised.
Hi BellyGas,
i could not understand. Please help me where i have to be changed in this code?
Are you need the excel file? then i will attached
A few problems... at the end you have one too many "end if" but also, you have
inside the for i = 1 to lr loop, and the End If for that is outside the For i... loop.Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
The best I can do is guess at the intended functionality and suggest trying this ammended code:
Please Login or Register to view this content.
Hi Arkadi,
i am using you code but getting the same error. I attached the excel file. please review and help me to resolve the issue
Hi there,
Try adding the highlighted line:
Please Login or Register to view this content.
Hope this helps - please let me know how you get on.
Regards,
Greg M
i am not getting an error with this code. But this code is unable to fetch the data. Please check where i have done mistake
@Greg M Oops, I had missed that, nice catch.
Any one please help me to find out where i have done a mistake in this code. Because, this code is unable to fetch the data based on selected date.
Please Login or Register to view this content.
Please help me on this. I can not understand how do i resolve the issue. Please help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks