I'm trying to count the number of columns in a table in an Excel 2010 VBA application called 'Sales' but getting a 'Variable not defined' error.
Do tables have to be defined separately from sheets ? If so, how ?
My code is as follows .....
Dim lgColumnCount As Long
lgColumnCount = Range(Sales).Columns.Count