Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a tabular control | Excel Discussion (Misc queries) | |||
Tabular to CSV style layout | Excel Programming | |||
Converting to tabular format? | Excel Programming | |||
Excel Vba -userform Tabular Column | Excel Programming | |||
tabular questionable | Excel Programming |