I have this vba code in my excel spreadsheet that specifies a range.
Instead of hardcoding the end range, I want to have it automatically find the very last row of data and select that as the end range.
Here is my line of code that I currently have:
ActiveSheet.ListObjects.Add(xlSrcRange, Range("$B$2:$AY$7370"), , xlYes).Name = "Pivot_Table" Set DataTable = ActiveSheet.ListObjects("Pivot_Table")
So instead of $AY$7370, I want it to automatically determine what the very last row is that contains data.
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>