Hi ,
The second check is invalid since we can never have row #0.
At the least , the line should be :
If ws.Cells(Rows.Count, 3).End(xlUp).Row > 1 Then
Both are equivalent if they are intended to recognize whether you have at least one row of data , based on which row your column headers are in.
If your headers are in row #1 , then your first row of data will be row #2. When you do .End(xlUp) , the cursor will either land on the last row of data , where ever that may be , or if there is no data , will land on the header row , where ever that may be.
Thus , if your header is in row #1 , the check should be :
If ws.Cells(Rows.Count, 3).End(xlUp).Row > 1 Then
If your header is in row #2 , the check should be :
If ws.Cells(Rows.Count, 3).End(xlUp).Row > 2 Then
and so on.
Narayan