Is there a way to use END and UP in a function statement?
I would like to be able to select the last entry of a row of data.
We use to do this in Lotus by using in a function by just using ={end}{up}
Thank you
Is there a way to use END and UP in a function statement?
I would like to be able to select the last entry of a row of data.
We use to do this in Lotus by using in a function by just using ={end}{up}
Thank you
Hi Tony1220 and welcome to the forum,
In Excel VBA you can assign the last non blank row number (LastRow) of a Column (say column A) using this VBA statement.
Is that what you wanted?Please Login or Register to view this content.
Using keystrokes you can do Ctrl+DownArrow to go the the end of a column. see http://www.exceltip.com/st/The_Best_...t_Excel/1.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks