Excel not responding, for this code.

[dinakar.yadav]

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.

[dinakar.yadav]

Using DO until is the problem? I also got an error, saying, "overflow error '6'). please help

[Olly]

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?

[dinakar.yadav]

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

[Olly]

Open the locals window, pres F8 to step through the code. What is the value of l when the Do... Loop starts?

[dinakar.yadav]

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

[dinakar.yadav]

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?

[Olly]

Can you attach a workbook, so I can check what is happening.

[dinakar.yadav]

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?

[Olly]

Glad we managed to point you in the right direction to fix it Thanks 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.