View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rachel Rachel is offline
external usenet poster
 
Posts: 113
Default count number of rows in 2 worksheets

HI,

Anyone can help? I need a macro code to count number of used rows in two
seperate worksheets and compare. If the number do not match error message
shall appear "Sheet1 has (blank) number and Sheet2 has (blank) number".
(blank) being the number of used rows per sheet. Can this be done? thanks!