Hi all
Using some VBA, I have a worksheet in mind and I would like to find out what the first number in a column (A)
and what the last number in column A is.
Assuming for arguments sake the first row is numbered 101 and the last row number 209 all in col A.
Peter
Posted elsewhere
https://www.ozgrid.com/forum/forum/h...nd-last-number
Last edited by Potholes; 10-24-2019 at 01:06 AM.
One I have learnt over the last few months, " You are NEVER too old to learn ".
Sometimes I forget to say " Thank You " for your assistance, so here I say " A BIG Thank You. "
These functions will work when called from other VBA code or within a macro; however, you cannot use them as UDFs (user defined functions) within a worksheet formula. Since you did not tell us the worksheet, I am assuming it is the active sheet when these functions are called (you can add sheet references if you want to be able to use them when the sheet is not active). These functions take one argument... the range you want to evaluate.
Note: These functions assume your values in the cells of the specified range are constants. If they are formulas, the change the red highlighted xlConstants to xlFormulas.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks