Hi Steve,
Yeah there is some limitation in excel too. :P
Once you convert your formula into static value, you can't get it back...And I can understand no one would love to loose formula so better you have options to paste the entire column in some other column and then can go for PASTESPECIAL-VALUE method as this one is left at last.
If your query has been solved, please take few seconds marking this thread as SOLVED and say thanks to the person by adding *Add Reputation.
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
adhawan06 - Yep you're right about that but I may just leave this post open for a day and see what comes back, may get another way to do what I am trying to achieve here, nonetheless cheers for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks