Deleting Data but not the formula

[sasuke]

How to delete data in the cells but not the formula in vba? Thanks

 

[Nebu]

Hi:

There are lot of info available over the net why don't you make use of google search.

http://stackoverflow.com/questions/4430755/excel-clearcontent-preserving-formulas

http://ccm.net/forum/affich-670119-vba-for-deleting-data-in-row-but-not-formulas

http://excelribbon.tips.net/T009097_Clearing_Everything_Except_Formulas.html


http://www.vbaexpress.com/forum/showthread.php?24366-VBA-to-Delete-cell-values-only

Thanks

 

[xlstime]

Hey sasuke,

please follow below steps -

Step 1 - Select your data range
Step 2 - Press Ctrl + G (Go to)
Step 3 - Click on Special (bottom left side)
Step 4 - Select Constants (2nd option) than from formula sub tab uncheck all apart from Logical

Than OK

Now delete your data using del key

How to delete data in the cells but not the formula in vba? Thanks