Re: $$Excel-Macros$$ Unlist - Table to be constant for every macro to run

2012-03-07 Thread Sam Mathai Chacko
*osh.ListObjects(1).UnList* Regards Sam Mathai Chacko On Wed, Mar 7, 2012 at 12:34 AM, dguillett1 dguille...@gmail.com wrote: try Sub removetableSAS() dim i as integer for i = 1 to 3 activesheet. osh.listobjects(Table i ).unlist next i End sub Don Guillett Microsoft MVP Excel

Re: $$Excel-Macros$$ Unlist - Table to be constant for every macro to run

2012-03-06 Thread dguillett1
try Sub removetableSAS() dim i as integer for i = 1 to 3 activesheet. osh.listobjects(Table i ).unlist next i End sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: yogananda muthaiah Sent: Tuesday, March 06, 2012 11:38 AM To: excel-macros@googlegroups.com