chenchanjuan
New Member
- Joined
- Apr 15, 2004
- Messages
- 20
Hello,
I have a question about the isblank function.
I have code like this:
Sub checkempty()
dim row as integer
For row=1 to 10
if [and(isblank(range(cells(row,1),cells(row,5)))] = T then
msgbox "all empty"
else msgbox "not all empty"
end if
next
End sub
If I use the isblank function without loop, say
if [and(isblank(A1:A5))] = T then blahblah
it works. Do you know how to add a loop into the isblank function?
Thank you so much
Cathy
I have a question about the isblank function.
I have code like this:
Sub checkempty()
dim row as integer
For row=1 to 10
if [and(isblank(range(cells(row,1),cells(row,5)))] = T then
msgbox "all empty"
else msgbox "not all empty"
end if
next
End sub
If I use the isblank function without loop, say
if [and(isblank(A1:A5))] = T then blahblah
it works. Do you know how to add a loop into the isblank function?
Thank you so much
Cathy