I've found this method for finding the last data containing row in a sheet:
ws.Range("A65536").End(xlUp).row
Is there a similar method for finding the last data containing column in a sheet?
excelvba
I've found this method for finding the last data containing row in a sheet:
ws.Range("A65536").End(xlUp).row
Is there a similar method for finding the last data containing column in a sheet?
Best Answer
Lots of ways to do this. The most reliable is find.
If you want to find the last column used in a particular row you can use:
Using used range (less reliable):
Using used range wont work if you have no data in column A. See here for another issue with used range:
See Here regarding resetting used range.