Determine Which Columns Are Hidden in VBA

[Guest]

I have a spreadsheet which will be used by individuals to update an
Access database. The columns are locked, but I do allow them to hide
columns to make the data more customized. Periodically they will
refresh their data from the database. In order to avoid forcing them
to reformat to their preference (and thus encourage them to refresh
more frequently) I would like to determine which columns they have
hidden so I can unhide, update/append the new data, then hide the
columns again. The same information would be advantageous, though
less so for the autofilter properties. I have tried in vain to look
at the help files and have not found the correct text with which to
search in this group to find the answer. Thanks in advance if you can
help.

 

[mray29]

Try this link for info on the VBA syntax:
http://techrepublic.com.com/5208-11192-0.html?forumID=42&threadID=177201