Relative locations to absolute locations using VBA

I am trying to solve how to turn relative locations into absolute locations using VBA.

I start with a document of unknown number of columns. I use the code below to go to the right-most column.

Please Login or Register  to view this content.

Question 1: How do I get the absolute location of my current, right-most cell?

Question 2: How do I turn this right-most column into a range of which I take the maximum value of?

The code below calculates the maximum value, but Arg1, and Arg2 needs to be my range, say, starting at row 2 and going to row 100,000 - and of the right-most column.

Please Login or Register  to view this content.

In the attached example the desired solution is 1,000.

ABS-REL LOCATIONS.xlsx

Yes, that is the answer I was looking for. Thank you.

The site below has more information on the type of solution posted here.

http://www.rondebruin.nl/win/s9/win005.htm