Method for selecting a dataset with varying number of rows

Hi!

I have a mostly-completed macro designed to assist in formatting a report that is pulled by a team member every day. The first step in this macro is to convert the data set into a table.

Effectively, I want to reproduce the native "Ctrl + L" functionality in my macro, so the data range isn't being set to "$A$1:$AH$273", but whatever range that specific data set is contained within.

I'm very green with VBA, and actually constructed this macro by using the Recorder, and then making changes to turn off refresh, screen scrolling, etc. -- so I'm sure there's a simple fix here I'm overlooking.

The table conversion portion of this code currently reads as:

ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$AH$273"), , xlYes).Name = _
"Table1"

Any help would be very much appreciated! Thanks!

Originally Posted by xladept

Something like:

Please Login or Register  to view this content.

This worked! Thank you so much!