Hi all,
i'm looking for a VBA for a problem in my quality report table.
I have one big sheet of data in which i have a lot of cells with "IF true" statements.
Is it possible to trigger Paste Special Values with VBA to the all "IF true" statements cells and the result must be in the same cells where is the formula with the IF true statement.
Best Regards
D.D
i will try to explain it in different way
in B1 - there is a formula with IF statement which trigger True. I want all cells in the
sheet in which cell there has been triggered IF > True statement formulas to copy there value to the same cell.
Best Regards
D.D
Last edited by archangel9999; 10-29-2012 at 06:07 AM.
Hi Archangel9999
It may be easier to post an example of your workbook showing the before and after conditions so we can see exactly what you are wanting the macro to do.
Just go to Advanced post and attach a file there.
Mowgli
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks