Save column J of WorkBook when WorkBook is not saved.

[mikeburg]

Need VBA code to save column J of open workbook called
LmbcAcctsPayable.xls, Sheet1, to same workbook & sheet called
LmbcAcctsPayable.xls, Sheet1, when save is not selected.

Reason: The workbook is usually not saved because it is more of a
templet with names in column A. Column J is updated with a date when a
row is used so I need the column J to copy automatically to the blank
templet when exiting without saving (using ThisWorkbook.Save = True in
Auto_Close). That way, rows not being used for a long period of time
can be periodically eleminated.

Thanks so very much. mikeburg

 

[bgeier]

The only way to save a given range is to copy that range to anothe
workbook then save that workbook

 

[mikeburg]

That's the only way I could find too! Thanks a million. mikebur