Reply to thread

Message: [QUOTE="Sheeloo, post: 3206619"] See [URL]http://www.rondebruin.nl/personal.htm[/URL] for instructions. Instructions are simple but the concept takes a little time... Here is the macro to use Sub pasteSpcial_Formulas() Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False End Sub Another way is to go to Copy a range of formula you want to copy Click on the destination Cell (single cell) Tools->Macros->Record a macro Choose Personal Workbook in the 'Store macro in...' option Give the macro a name or live with the default Do your paste special Stop recording Then create a button, assign the macro recorded above to the button. It seems a lot but believe me it is worth the effort and it will save you hours in future... [/QUOTE]