hi,
Code below starts putting data at row A23 but not A20. Should start at A20. Can someone please help. Thanks
Please Login or Register to view this content.
hi,
Code below starts putting data at row A23 but not A20. Should start at A20. Can someone please help. Thanks
Please Login or Register to view this content.
Obviously value of A is 3 in the beginning, not 0 as you expect
If you are pleased with a member's answer then use the Star icon to rate it.
will refer to cell A20 only if A is 0.Please Login or Register to view this content.
If it starts to put values from A23, it means A is 3 (i.e. A23 is 3 rows offset form A20)
from your code it's not possible to say how/when value of A become 3
Do you mean like this?
Please Login or Register to view this content.
Given the fact that we don't see full sub code I would not start playing around with value of A just before the loop. You don't know if and how it will affect rest of the code.
I would assume A is used before that piece of code, otherwise if it is integer/long it's default value, without initialization would be 0 anyway.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks