Loop macro to activate cell and then move to next cell

[1021557]

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.

Thanks

Mike

 

[VoG]

Like this?

Sub Blks()
Columns("A").SpecialCells(xlCellTypeBlanks).Select
End Sub

 

[texasalynn]

what do you mean "activate it"?

 

[1021557]

"Ativate" as in enter the cell and then move on to the next cell below.

 

[texasalynn]

I'm sorry but what would be the purpose of that? It won't provide any value added? Unless I'm not understanding.

 

[1021557]

Yup I knew someone was going to ask that It's imported form another programme and if you don't enter each cell the lookup formula that I have doesn't work, once you enter the cell and move on it does. Can you help?

Thanks

Mike

 

[texasalynn]

ok take a look at this