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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.