View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ladyhawke ladyhawke is offline
external usenet poster
 
Posts: 23
Default Detect lines in specific sheet at load time

I would like to provide a message box to inform the user if a specific
sheet contains rows with content after row 10.

How can this be done and can I make a sub for it so it returns true if
rows are there rows in that sheet. That would be useful when performing
the action that might insert info there (to warn the users of new
information available)

regards,
Ladyhawke