Loop into Excel

**ankit_ddit** · 03-10-2009, 05:47 AM

How to check that excel has end of data in worksheet using VB or C#

**Bob Phillips** · 03-10-2009, 05:53 AM

[vba]

LastRow = Cells(Rows.Count, "A").End(xlUp).Row
[/vba]

**mikerickson** · 03-10-2009, 05:54 AM

[VBA]MsgBox Range("A:A").Cells(Rows.Count,1).End(xlup).Address & _
" is the last cell with data in column A."
[/VBA]

**ankit_ddit** · 03-10-2009, 05:59 AM

what is rows here..

**Bob Phillips** · 03-10-2009, 06:06 AM

Rows is an Excel object referring to the rows in a worksheet.

**ankit_ddit** · 03-10-2009, 06:27 AM

u have idea how to check that row has data or not..

**Bob Phillips** · 03-10-2009, 09:24 AM

[vba]

If Application.COUNTA(Rows(1)) > 0 Then

...
[/vba]

Thread: Loop into Excel