Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with data sets with disparate dates | Excel Discussion (Misc queries) | |||
trying to add up disparate transaction data | Excel Worksheet Functions | |||
how to efficiently send many rows of data on a worksheet to the database using vba? | Excel Programming | |||
how do you send a email from an specific excel column (database).. | Excel Programming | |||
How to send data from Excel to a Database | Excel Programming |