Here's an easy one........saving when populated

V

Vato Loco

I have a sheet that needs to save everytime a certain range of cells i
populated. whenever something is typed in a4:iv4, I would like it t
save without prompting. It would also be great if it could save as th
value of a3. If anyone has a fix for this, I would greatly appreciat
the help.

Have a great day everyone, and thanks......Vato
 
D

Don Guillett

Might be nice to know how it is populated and if iv4 always has to be filled
out. Otherwise, you might be saving on each entry.
 
V

Vato Loco

It would be manually entered...and I want it to save each time somethin
is entered in that range. Thank
 
D

Don Guillett

Are you saying that you want the workbook saved each time ANY entry is made
in ANY cell in that range? if so
right click sheettab>view code>left window select worksheet>right window
select worksheet_change
use this inside the macroActiveWorkbook.Save
 
Top