Hi Can anyone help me write a macro that will select all the non blank cells in column 'A' of my spreadsheet. All I want to do is for excel to go into each cell in col. A, activate it and move on to the next non blank untilk it reaches the end. I don't want to change the data in the cells.![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
Thanks
Mike
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
Thanks
Mike