Thread
:
countblank
View Single Post
#
1
Posted to microsoft.public.excel.programming
Alberto Ast[_2_]
external usenet poster
Posts: 181
countblank
How do I use countblank in a macro, I got as follows but it gives me an error
Sub Clear()
If CountBlank(ActiveCell.Resize(1, 19)) 0 Then
Range("A1").Select
Else
Range("B1").Select
End If
End Sub
Reply With Quote
Alberto Ast[_2_]
View Public Profile
Find all posts by Alberto Ast[_2_]