Forum Discussion
Excel Table Size in Macro
Hi, I download external Excel information and run a macro I created for it. It works great. However, the external info I download grows every week with new rows and when I run the macro, the new row...
Using the CurrentRegion property, you may try something like this...
ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1").CurrentRegion, , xlYes).Name = "Table1"
Subodh_Tiwari_sktneer Thanks so much. Several responded with the same info and it worked. Very much appreciated.