I have see a few ways to count the rows and have tried to put it in my vba every way I can think of and I cant get it to work. I am still new to all this vba stuff so thanks in advance for your patience. Here is my current rangeThe I170 will be the one that changes and I would like to auto size the table to fit the data. Thanks again!
ActiveSheet.ListObjects.Add(xlSrcRange, Range("$F$1:$I$170"), , xlYes).Name = _ "Table4"