I'm trying to use ActiveCell.Column to store a column letter in a variable to be used later.
Only trouble is that it is returning a number instead of a letter. So column C shows up as 3.
Is there a way to make the function return the letter?
I'm using this to store the column letter so that I can move to known rows within a variable column that need to be pasted to another sheet.
Thanks in advance for any help.
Only trouble is that it is returning a number instead of a letter. So column C shows up as 3.
Is there a way to make the function return the letter?
I'm using this to store the column letter so that I can move to known rows within a variable column that need to be pasted to another sheet.
Thanks in advance for any help.