Hi guys,
What's the issues with that please ?
I want to :
-Introduce new column after "M"
-Name it Description in the first row
-put this formula : =Today() & M2
-Fill down until the last non empty
-copy paste values
-delete "M"
Thanks a lot
Please Login or Register to view this content.
what are the issues, right now? I can tell you that the formula has an issue because date() is a function that needs something inside the brackets.... if you want the current date, it is today()
also, you are calculating last row based column N, but since you just inserted column N......
Last edited by Arkadi; 05-29-2015 at 01:44 PM.
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.
Maybe:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Oh yes that's actually better.... that was easy...
Do you how I can also format the column so that when I use the today function within the vba, the column is in the text format ?
Thank you.
Yes all good guys ! thanks !
Do you guys know by any chance how to perform the today + concatenate only on non empty cells ?
Thank you so much.
-guillaume
So many ways to get this wrong.... best to shows us a workbook with BEFORE and AFTER sheets.
Last edited by JBeaucaire; 06-02-2015 at 02:07 PM.
Hum doesn't work... Still put the today function in the cell...
Thank you for your help JBeaucaire !
Any other ideas ?
thank you.
Did you see my request in post #7?
Yes sorry Didn't see that... I don't know why.
Workbook.xlsx
You can see the examples now, i believe it's not that hard.
I want to apply the formula in the macro to the non empty cells in column N.
Thank you !!
Like so:
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.Please Login or Register to view this content.
Perfect ! work like a charm !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks