tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I want to know if there is a better way to convert a range of cells from formulas to values other then the copy paste value method I use at the moment,
Currently I use this in my macro
But I'm thinking there must be a more correct way to do this,
the reason I ask is I've got loads of these type odes in my spreadsheet and it makes the macro run slow as its having to got to the sheet select the area copy and paste,
is there a better way to do this?
any ideas would help
thanks
Tony
I want to know if there is a better way to convert a range of cells from formulas to values other then the copy paste value method I use at the moment,
Currently I use this in my macro
Code:
Sheets("Dashboard WK").Range("C14:T33").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
But I'm thinking there must be a more correct way to do this,
the reason I ask is I've got loads of these type odes in my spreadsheet and it makes the macro run slow as its having to got to the sheet select the area copy and paste,
is there a better way to do this?
any ideas would help
thanks
Tony