Hello. I have used special select to select all blanks in a column (non-adjacent). I then copied a formula into all of these cells. However, now I want to copy paste special values over all of these formulas and it won't allow me to do so. I have other formulas in the column but I don't want to copy paste special values over these; just the cells that were formerly blank. How can I do this?
Can you use a macro? This is effectively Paste Special Values
Please Login or Register to view this content.
Last edited by mehmetcik; 06-13-2015 at 06:02 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Sounds to me like you now just have a whole bunch of different formulas, and you want excel to be able to ID certain of them?
Not sure there are any regular formulas that will do that for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Cross post here:
http://www.mrexcel.com/forum/excel-q...ste-value.html
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks