i need a macro that will select all the blank cells in a column.
-thanks
i need a macro that will select all the blank cells in a column.
-thanks
Re: select blank cells
Thanks Wigi .... :whip:
Re: select blank cells
But, you know he's going to select them when he doesn't need to anyway ...;)
Re: select blank cells
Agree, no need to select. However, On Error Resume Next is good practice so the code doesn't bug when/if there are no blanks in the data
Sub Macro1()
On Error Resume Next
Columns("A:A").SpecialCells(xlCellTypeBlanks).Select
On Error GoTo 0
End Sub
Details here on the SpecialCells Method
Don’t have an account yet? Register yourself now and be a part of our community!