Good question.

The data the user has in their sheet should, for the most part be in a
rectangular shape and most if not all cells in the rectangle should be
populated. There should not be any stray data in the sheet.

"Nigel" wrote:

Are you saying that unless a range is selected an error is required or if
the activesheet is empty of any data?

--
Cheers
Nigel



"quartz" wrote in message
...
I am using Office 2003 on Windows XP.

I have a custom program for certain users, but as an error check, the
program needs to determine if the activesheet contains a tabular list of
data. For ease of use and flexibility, I don't want the user to have to
define a list, table, or range.

Most users will know that they need a starting tabular list (which could
span from 1 to 100 columns and any number of rows), so most of the time it
would run correctly. But if someone new, or someone just forgot, it would
be
nice if there were some sort of auto-detecting code that could determine
this
and generate a custom error message.

Any ideas on how to do this programmatically in VBA?

Thanks much in advance.