Solved: delete content after save

[reza_doang]

hi all,

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

many thanks for ur help

reza

[Simon Lloyd]

We need more info to help you properly but.........[VBA]Range("B6:B2000").ClearContents[/VBA]

[reza_doang]

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]

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.