Hi all,
I'm trying to create a simple macro that will select multiple cells that are adjacent in a column.
This will be used on several worksheets, and some contain a number of blanks that I want to include.
The list will always begin in say A1, but each will be of differing lengths. I imagined having an "END" or similar value at the very bottom of each list and perform multiple ctrl+shift+down until End is reached, the loop will stop and a copy paste will be carried out and the macro will end.
I realise that this is straightforward but am quite a novice!
Thanks,
Chris
I'm trying to create a simple macro that will select multiple cells that are adjacent in a column.
This will be used on several worksheets, and some contain a number of blanks that I want to include.
The list will always begin in say A1, but each will be of differing lengths. I imagined having an "END" or similar value at the very bottom of each list and perform multiple ctrl+shift+down until End is reached, the loop will stop and a copy paste will be carried out and the macro will end.
I realise that this is straightforward but am quite a novice!
Thanks,
Chris