Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
what VALUES are in the variables, especially k
"Philosophaie" wrote: No luck I still erroe and highlighted "PupA" with the red break point underneath. "Sam Wilson" wrote: Hmm. Maybe put the cursor in the line "PupA = A - Pup" and press F9 to insert a break point, then, run your code and when it hit's the break point examine the values of your various variables. Sam "Philosophaie" wrote: Still not liking the subtraction of "PupA = A - Pup" or "PAdown = Adown - P" when you take out "PupA". Still think it is the "Pup = .cells(k+1,10)" and "Adown=.cells(k+1,10)" when "P = .Cells(k + 2, 5)" and "A = .Cells(k + 2, 10)". Is the k+1 vs k+2 fouling things up? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Iteration | Excel Worksheet Functions | |||
Procedure level array not recognised at module level | Excel Programming | |||
workbook level name vs worksheet level name | Excel Programming | |||
Using macro to convert single level BOM to Multi Level BOM | Excel Programming | |||
Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming |