I have a spreadsheet with a lot of formulas. Not all the formulas are the same. I would like to use VBA to find any formula that starts with "=IF(BDH(" and copy and paste special the values of that formula. I would think this would be fairly easy, but after hours of searching the web I still haven't found the right code. Any help would be greatly appreciated.
Ctrl+F, in the Find box, enter "=IF(BDH(" sans quotes, and select Lookin: Formulas from the dropdown.
Entia non sunt multiplicanda sine necessitate
Thanks for the response but unfortunately I had tried that already and it doesn't work. It certainly finds all the formulas, but since it highlights multiple selections you can't then copy that and paste special values because when you hit copy excel gives a warning message that says "That command cannot be used on multiple selections". That's why I think I need VBA code to find each formula and copy paste special values. Anybody know the code to do this?
Last edited by stmmoore23; 03-05-2013 at 07:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks