The following was working perfectly until now (It is now past 2000 rows - I don't believe this to affect anything, but I am mentioning it just for background info.)
The following is called from another module where dCol = Column Letter; dCounter = Row Number.
Here is the createButton():
During my debugging, I verified the following:
1) The range "r" that is received in createButton is the correct range. (Returns the value at that range when called through msgbox)
2) When button.add is being executed, the "r" is still the correct range. (Returns the value at that range when called through msgbox)
3) When the button is actually created, it shows up 2 rows above where it was told to be created. (Why is this happening is my question.)
4) Errors occur because when the rest of the code is trying to change the label of the button, the button is not in the correct location - because it's 2 rows above.
Thank you for any help!
I had to do a workaround and it does work, but it is definitely NOT a robust fix. Here it is:
Bookmarks