Hi All
Thanks to date for all the previous assistance has really hepled me in understanding more about Macros and working through shortening what was very long winded Macros.
The issue I am having is selecting a range of cells with formulas and hard coding them.
Code
Sub PASTE_special_FORMULAS()
Range("E8:P18,E22:P32,E36:P46,E50:P60,E64:P74,E78:P88").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Is there a way of pasting values for ranges without having to have a macro for each range
Thanks again
Lee