I am using ...
... to convert the range A2
the last column/row in the range) to a table ...
The problem is that there are blanks in column A, which means that the NewTable is only down to the row before the first blank!
Is there a way round this?
Thanks ...
VBA Code:
ActiveSheet.ListObjects.Add(xlSrcRange, Range([A2].End(xlDown), [A2].End(xlToRight)), , xlYes).Name = "NewTable"
... to convert the range A2

The problem is that there are blanks in column A, which means that the NewTable is only down to the row before the first blank!
Is there a way round this?
Thanks ...