LinkBack URL
About LinkBacks
Hi guys,
While running the following code,my excel is hanging. Not sure, what exactly is the problem, Please help.
Please Login or Register to view this content.
Excel not responding, for this code.
Hi guys,
While running the following code,my excel is hanging. Not sure, what exactly is the problem, Please help.
Please Login or Register to view this content.
Last edited by dinakar.yadav; 04-10-2014 at 07:35 AM.
Using DO until is the problem? I also got an error, saying, "overflow error '6'). please help
Please use CODE tags when you post code.
Have you tried stepping through your code, to see where it fails? Is it getting stuck in the Do Until... Loop, due to an unexpected value of variable l, perhaps?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Sorry! I am new to the forum, so dint know about the tags.
Its getting stuck at this point. "Cells(4, k).Value = i * j & "-" & i * (j + 1)". And also when i tried get value of "(Int(l / i) + 4)"
in the immdediate window, an error pops up saying "overflow, error '6')
Thanks,
Dinakar
Open the locals window, pres F8 to step through the code. What is the value of l when the Do... Loop starts?
The range, I am specifying for the value of l is a2:A1000 expecting the value as 90. But its taking the value as 0
"Row Labels Count of CaseID
0 1
1 11
89 1
90 1
Grand Total 15
Also I am not able to see the value of the variable l, when i hover the cursor on the variable l. What could be the reason?
Can you attach a workbook, so I can check what is happening.
Olly! issue is resolved! like you said, the range for l was taking few character values,hence the problem. How do i change the tread to solved?
Glad we managed to point you in the right direction to fix itThanks for the feedback.
To mark thread solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks