I have a very simple question, but for the life of me can not seem to get the answer from online, way too many and too complex solutions for what I am trying to find.

I simply need to know how to change the following code to replace the Z3 ending cell, to the same row, but last column that has data. This will be used in variety of different sheets, so the last column will not always be Z, it may be H, AA, etc etc etc.

Can some one please answer this simple question as all the articles I have seen are very complex or just trying to find the value of the last cell with data, which is not what I am looking for.

Range("A3:Z3").Select