Odd behaviour of creating a table in VBA

Johnny C · Sep 5, 2017

I'm creating a lot of tables so am using VBA.

This doesn't work ...

Code:

InputName = "Input_" & ActiveSheet.Name
ActiveSheet.ListObjects.Add(xlSrcRange, Range("$B$12:$C$38"), , xlYes).Name = Input_Name

But this does ...

Code:

ActiveSheet.ListObjects.Add(xlSrcRange, Range("$B$12:$C$38"), , xlYes).Name = "Input_" & ActiveSheet.Name

why is that?

Domenic · Sep 5, 2017

It looks like you meant...

Code:

ActiveSheet.ListObjects.Add(xlSrcRange, Range("$B$12:$C$38"), , xlYes).Name = [COLOR=#ff0000]InputName[/COLOR]

Johnny C · Sep 5, 2017

Doh... Brain meltdown after a day of indirect errors and table vba