Hello Excel Experts,
I had helped here with the "automatic" of knowing the last row without VBA. This time, I want the reverse, which is the last column.
I wonder if there's a way to find the last column "automatically" through name range. I have the code below, but it's not working properly
Reason I want to do it this way is so that Named Range could automatically know what is the last column IF users were to put additional data.
Example: Currently Columns were only from A-H...if users were to put more data, say until Z, named range would be from A-Z
Bookmarks