What do you want to save?
Add Code snippet
New code examples in category VBA
-
Amir Uval 2021-09-04 09:33:01
excel clear contents and formatting of cell with a single command
'To clear a worksheet range from VBA, use one of 'the 'Clear' methtods: [A1].Clear '<-- clears everything in the Range cells [A1].ClearFormats '<-- clears only the formats [A1].ClearContents '<-- clears values but not formats [A1]... Add solution -
Rthavi 2021-09-03 21:18:02
excel vba automatic calculation
Sub CalculationMode() ' To manual Application.Calculation = xlManual ' One shot Recalculation (one worksheet), keeps Calculation mode to manual ThisWorkbook.Worksheets(1).Calculate ' To automatic Application.Calculation = xlAutomat... Add solution