Hello all,
I'm testing the function of a simple for next loop. I manually put the values 1 through 10 in cells A1 to A10, then I am running a test macro to place the values from A1:A10 into C1:C10, C11:C20, and C21:C30. My code works, but it also puts "#N/A" in cell C31. My example code is below. Does anyone know why it's adding the #N/A?
Thanks
Please Login or Register to view this content.
Hi, mcclanat,
makes it 11 instead of 10, 21 not 20, 31 not 30.Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
That makes sense. Thanks!
Out of curiosity, why do you set the ranges to nothing at the end?
Hi, mcclanat,
sort of cleaning up at the end of what I set up before. According to MS the scope of the variables should end with the end of the procedure but if you work with another Office program not setting the objects to nothing might cause problems there. To avoid these I simply use the clean up in opposite order to the setting at the end (not resolving the objects in the proper order might cause other problems which I prefer not to have).
HTH,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks