VBA -How to keep existing range column headers when converting to table

Please Login or Register  to view this content.

That's my [found on internet forum] code for turning an existing range into a formatted table. Row 2 has headers, but running this code strips them out and inserts the default "Column 1", "Column 2", etc.
I'm new enough to VBA to know there's a simple fix, but haven't found it yet. Help?

Hi Quinn.Farley,

Your error is caused by a typo.
Your x1Yes should be xlYes. You have a one instead of a lower case L.

In their not so infinite wisdom, the Microsoft people should have avoided the lower case L.

Your error is also caused by the lack of 'Option Explicit', which would have caught the error as a compile error.


It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis

That was it! Thank you very much for your help, LJ Metzger. Works perfectly now. I don't have a good grasp about "option explicit", but will research and learn it now.