|I have found the following macro on your site and it works but it copies the formula instead of the values.|
I need help in editing the macro--I have researched this problem and the solution is PasteSpecial but I do not know how to incorporate into this code??
I am new to this site and I am not sure if I posted this twice??
Here is the macro:
Dim rngFind As Range
Set rngFind = .Find("Totals", _