I am trying to record a macro that copies numbers from one cell and paste into a comment, when recording, I copied the numbers from the formula bar and then pasted into the comment. However, every time when I run the macro, it repeatedly pastes the exactly same number I copied during recording...