Locate Last Row and use the corresponding row number to define a Range

[D18GE]

I'm having trouble with the task of writing the code inside a macro to perform the task of locating the last active row of data on an open spreadsheet and then using the corresponding row number to define the Range of A10:Zxx A10 is the beginning row/column cell and Z is a known last column but xx is unknown. Once the Range is defined I desire to format the entire range with borders around the edges and middle. Any help is greatly appreciated. Cheers !

 

[MARK858]

Cross-posted here Macro Help to Locate Last Row of Data and Open another workbook from users desktop

Cross-Posting… Why you are asked to provide a link