PDA

View Full Version : Solved: delete content after save



reza_doang
08-23-2010, 01:50 AM
hi all,

can someone provide me using vba how to delete values for columns B6:B2000.

many thanks for ur help

reza

Simon Lloyd
08-23-2010, 01:53 AM
We need more info to help you properly but.........Range("B6:B2000").ClearContents

reza_doang
08-23-2010, 02:05 AM
my mistake,
i didn't explain clearly...

after saving my file, i need to delete any values for only in col B6:B2000.

yesterday you gave me a vba for saving file
http://www.vbaexpress.com/forum/showthread.php?t=33697
now, i want to modify a little, after saving file can col B6:B will delete values in that cells.

thanks

Simon Lloyd
08-23-2010, 04:28 AM
If you clear values or make changes when you close the workbook you will still be asked to save the changes!, that said the code i gave you above will clear those values.