Re: $$Excel-Macros$$ Determine if dynamic range contains any rows

2010-12-21 Thread 0 1
That did the trick, Paul. Thank you. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.c

Re: $$Excel-Macros$$ Determine if dynamic range contains any rows

2010-12-21 Thread Paul Schreiner
Try this:     Dim rowcnt     Err.Clear     On Error Resume Next     rowcnt = Range("MyRange").Rows.Count     If (Err) Then     MsgBox "No More Rows!"     Exit Sub     Else     On Error GoTo 0     End If Paul From: 0 1 To: MS EXCEL AND VBA MACROS