need code that will convert a table to a range

[RuthMP]

Hi,
I'm not a programmer; I usually just create macros by recording them as I'm formatting output (and I edit them a bit), as the outputs I format are standard from month to month. However, I'm having a problem that I've never had before, in that when I try to record converting a table to range (an option on the ribbon in the tables tab, table options) for some reason, that action won't record. Is there any code that will accomplish conversion of a table to a range?

The reason I want to do this is because when the table is created, it applies the filter at the wrong location, so I want to apply the filter to a different location, but keep the nice color formatting that is applied when output is formatted as a table. The weird thing is that even though when I use the "record macro button" it will record the steps in the creation of the table (insert table), but when the table has been created, and I choose "convert to range" in the tools section of table tools, the fact that I have selected this doesn't get recorded. I've been recording macros for many years now, and this is the first time I haven't been able to record an action. It has me stumped!

Thanks, in advance for any suggestions!

[JBeaucaire]

The .Unlist command will remove the table properties while leaving the pretty formatting behind.
Replace Activecell reference with whatever anchoring method you need, but this is the syntax to do it:

Please Login or Register  to view this content.

[RuthMP]

Thank you, thank you. I'll try this tomorrow, and if it works I'll add to your reputation! I still don't understand why I wasn't able to record that action, but I'm very glad there is a way. I plan to use this on an iterative process which creates 50-70 separate worksheets, so if this does work it will be a huge timesaver!

[JBeaucaire]

Glad to help.

If that resolves your question, please select "Mark as Solved" from the Thread Tools at the top of the page. Thanks.

[RuthMP]

This worked perfectly, exactly as written! Thanks so much! I love this site, and so appreciate all the offers to help! You've made my day.... and you make me look good!!! Happy Easter... happy spring!