Best way to send disparate cells to database
 

I have a spreadsheet where cells are interspersed through out the a
spreadsheet.

I need to keep track of the cells that changed and send them in batch
to a database to update...what would be best way to do this?

Best way to send disparate cells to database
 

Hi there,

I am sorry, the event to write code for is actually Worksheet_Change!

The Target range will have as many cells as makes sense for the action
that caused the event to fire. For example, if you just change the
value of one cell, the event will fire with Target.Cells.Count = 1,
but if you do a fill down of a value to 9 cells below the original
cell, the event will fire once with Target.Cells.Count = 9.

Hope that makes sense!

Colby