Hi all, I am using the following code:
In my macro to get the results of a formula that calculates dates to just paste back the resulting values, but it doesn't appear to work. Can anyone tell me what's wrong please?
Please Login or Register to view this content.
Helen
Last edited by HelenW; 12-05-2008 at 08:04 AM.
There is nothing wrong with the formula...
What the error u r getting.
Shijesh Kumar
http://shijesh.wordpress.com/
No error, but it just doesn't paste the values - it still displays the formula when you click the cell. I just want it to paste the result of the formula i.e. a date in the format dd/mm/yyyy and no longer have the formula "in the background" as it were.
I check the code on my system it working.
Can you post the workbook as attachment, so that I can check why its not working.
Have attached it as requested - I am trying to get the values to display in column L.
Hi,
In the sheet attached, I see that the date formula is in column L and not in column M
Use the below code it should work
Please Login or Register to view this content.
Oh, I am an idiot! Sometimes it takes that extra pair of eyes to spot the obvious mistake LOL
Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks