Hello All,

I am creating a macro that will create a table from a selection and then format it appropriately. I use an input box to name the table, but then I'm not sure how to refer to this table in the VBA code since it's name will be different each time the macro is used. Here is a portion of the code so far:

ActiveSheet.ListObjects.Add(xlSrcRange, Range("$L$1:$N$3"), , xlYes).Name = _
        InputBox("What is the name of the table?")
    Range("Table9[#All]").Select
I'm not sure what to use to replace "Table9" so that whatever name was just keyed in by the user is referred to.

Any help would be greatly appreciated. Thanks!

Joe