Hi All,
Im am trying to use the find function to return the column letter in order to fetch the latest date in that column :
Still an amateur here so any guidance would be useful, thanks!Please Login or Register to view this content.
Hi All,
Im am trying to use the find function to return the column letter in order to fetch the latest date in that column :
Still an amateur here so any guidance would be useful, thanks!Please Login or Register to view this content.
Last edited by Muktar888; 06-02-2020 at 07:43 AM.
FYI - for code, use code tags (# on the ribbon), not quote tags (speech bubble on the ribbon). I've fixed it for you tioday. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
No sample workbook, no explanation of what is specifically going wrong with your code, but I do see one issue:
is missing a colon and you don't need the extra "&", and rfind being a variable, it should not be in quotes:Please Login or Register to view this content.
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks