I want to get a return value of date in column C whereas column A represent a date and column B represent a number. Simplest formula in excel is Column C (Feb 26, 2014)= Column A (Feb 21, 2014) + Column B (5). I want it to have in macro code. Thank you!
Try this code....
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi, :) Sixthsense :),
Concatenation between Date and Alphanumeric character like S should be made by using ampersand, not plus?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
BTW I want to insert this code in a change event trigger and this code should be present in the columns I've mentioned.
Holger,
Not sure from where you got the alpha?
Column AOriginally Posted by jayce_sos
Feb 21, 2014
Column B
5
Column C
Feb 26, 2014
Hi, :) Sixthsense :),
my fault - I misread the 5 as S - maybe either have a go for new specs or change the font displayed (at least the size of it).
Ciao,
Holger
Hi, jayce_sos,
maybe like this:
Ciao,Please Login or Register to view this content.
Holger
Sixthsense,
I tried your code but its keep on computing. I have to terminate the xls file.
Hi Holger,
It will be easier for us if the OP's shows the data in the way I shown in Post #5 without mingling it with the running text
Hi, jayce_sos,
could you please show the code that you used as I doubt you put in the code supplied without changes to it which could result in a loop. Maybe try the event-code I supplied.
Ciao,
Holger
Holger,
You've nailed it brother! Thank you!
Because it's working with entire range of data which is designed based on the post #1 description.
For your revised requirement, use the code provided by Holger in Post #7.
Holger,
You've nailed it brother! Thank you!
Thanks also Sixthsense!
Hi, jayce_sos,
you could make it more failproof by restricting it to the used range on the sheet as well as add a check if both cells are filled (this code will delete column C if Column A is empty and place date from A to C if B is empty):
Ciao,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks