Tuesday
Oct092007
check to make sure every sheet has the same number of rows in two files: VBA excel help

'sheet1 in the first boook is compared to sheet1 in the second book.
For X = 1 To File1.Sheets.Count
If File1.Sheets(X).UsedRange.Rows.Count <>
File2.Sheets(X).UsedRange.Rows.Count Then _
MsgBox "The worksheet: " & File1.Sheets(X).Name & vbCrLf & _
" in workbook: _
" & File1.Name & vbCrLf & " does not contain the same number of rows as " _
& vbCrLf & File2.Sheets(X).Name & " in " & File2.Name
End If
Next
Reader Comments (1)
Thank for your time to share us this discuss, i have some opinion on the <a href="http://www.dressaler.com/" title="Formal Dresses">Formal Dresses</a>, I feel so stronl about your article, and learning more on this topic, then it is so good, Do you have time visit us <a href="http://www.dressaler.com/wedding-party-dress/bridesmaid-dresses.html" title="Wedding Bridesmaid Dresses">Wedding Bridesmaid Dresses</a>.I will bookmark your blog and have my kids check up here frequently <a href="http://www.dressaler.com/wedding-party-dress/junior-bridesmaid-dresses.html" title="Junior Bridesmaid Dresses">Junior Bridesmaid Dresses</a>. I’m very certain they will understand lots of new stuff here than anybody else. I do appreciate that youve added relevant and intelligent commentary here though. Thank you!