Cavaliere
03-28-2010, 08:36 AM
Hi everybody,
Is there any function in VB that represents the following loop
w = 0
For k = 1 To ActiveSheet.UsedRange.Columns.Count
If ActiveSheet.Cells(2, k) = Empty Then
w = w + 1
End If
Next k
if w < ActiveSheet.UsedRange.Columns.Count then
MsgBox "Row is not Empty"
Thanks in advance
Is there any function in VB that represents the following loop
w = 0
For k = 1 To ActiveSheet.UsedRange.Columns.Count
If ActiveSheet.Cells(2, k) = Empty Then
w = w + 1
End If
Next k
if w < ActiveSheet.UsedRange.Columns.Count then
MsgBox "Row is not Empty"
Thanks in advance