Hi,
Could anyone please suggest me the code to check if there in particular sheet, is there any data in 2nd visible row(after filters) and if there is no data, then 'call other macro'
I am using below code But somehow when it goes to the 'Bold' line, it directly exits the macro. I am not sure why is happening. Please help.
Thank you in advance
Could anyone please suggest me the code to check if there in particular sheet, is there any data in 2nd visible row(after filters) and if there is no data, then 'call other macro'
I am using below code But somehow when it goes to the 'Bold' line, it directly exits the macro. I am not sure why is happening. Please help.
Code:
With ActiveSheet.usedrange.SpecialCells(12)
[B]If .Areas.Count = 1 And .Areas(1).Rows.Count = 1 Then Exit Sub[/B]
If .Areas(1).Rows.Count = 1 Then
If Application.CountA(.Areas(2).Rows(1)) = 0 Then
Call pastingcounselordataKeralaexcept21
Exit Sub
End If
Else
If Application.CountA(.Areas(1).Rows(2)) = 0 Then
Call pastingcounselordataKeralaexcept21
Exit Sub
End If
End If
End With
Thank you in advance