Hi all,
i have a simple question. i would like to increase the month by one. i know that there is the "dateadd" function. however, coding error "type mismatch" occurs when i tried to run the macro.
this is what i had done:
current month : sep10
Please Login or Register to view this content.
next month : oct10 (results from using macro)
i am pretty sure that the coding for this is very straightforward but i cant seem to find any solution online. any help would be greatly appreciated
Last edited by dan2010; 09-14-2010 at 04:14 AM.
Try just:
Please Login or Register to view this content.
and then just format the cells as you require.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
i have managed to get "sep10" withhowever for the value of the next month, it shows "Oct-10" instead of "oct10" withPlease Login or Register to view this content.do u have any suggestions how can i change the format of the date to "oct10"?Please Login or Register to view this content.
thanks
You'll need to format the cells as text I think otherwise Excel will try and help out by converting what it sees as dates to serial date values:
Please Login or Register to view this content.
Dom
that is perfect. thank you very much Dom and have a nice day :D
ps:what does "@" mean?
It's just the code for formatting a cell as text.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks