I have a macro containing the following line:
Set Rng = Columns(1)
I understand the that the #1 after Columns indicates column A. I want, however to have the macro work with a range of columns from A through M. I have tried Columns(1:10), but it doesn't like it. Any help would be appreciated.
Thanks in advance.
Set Rng = Columns(1)
I understand the that the #1 after Columns indicates column A. I want, however to have the macro work with a range of columns from A through M. I have tried Columns(1:10), but it doesn't like it. Any help would be appreciated.
Thanks in advance.