I have this code i have wrote below but have some problems occuring i can't seem to figure out. I have put the code that needs to be changed in bold:
The existing code i have moves a command button and macro function to the active cell row. The problem that I'm having is after copying the cells i need, it overwrites previous data in RANGE N41. I need it to paste in the next empty cell in range N41:N48.. The next problem i am having is clearing the contents of where the original cells were copied. After pasting, the code selects a different cell and changes the active row. This makes it clear contents of the incorrect row. I tried clearing contents of the row after copying, but this clears what was copied to clipboard as well and gives me an error. Is there a way i can store the correct row as a variable and reference later in code?
Bookmarks