Hi
I am trying to write a maco to sort on column A, each time the marco is to be run the range of data may be different.
The width can vary number of columns increases or decreases, length can vary number of row increase or decrease.
Can anyone give me a clue as to how to set dynamic ranges to cope with the above scenario.
Thank you in advance
Coop123
I am trying to write a maco to sort on column A, each time the marco is to be run the range of data may be different.
The width can vary number of columns increases or decreases, length can vary number of row increase or decrease.
Can anyone give me a clue as to how to set dynamic ranges to cope with the above scenario.
Thank you in advance
Coop123