| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy values in a range to memory
Hi,
I was wondering how I could go about copying a range's values to memory. I'm creating an audit system where I need to capture the old values and the new values upon a change. A delete of multiple cells doesn't seem to be captured. Can you use 2-D arrays in Excel's VBScript? Thanks, Ryan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy values in a range to memory
nevermind...I got it ;)
ReDim OldValueArray(1 To Target.Rows.Count, 1 To Target.Columns.Count) "rchan11" wrote: Hi, I was wondering how I could go about copying a range's values to memory. I'm creating an audit system where I need to capture the old values and the new values upon a change. A delete of multiple cells doesn't seem to be captured. Can you use 2-D arrays in Excel's VBScript? Thanks, Ryan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and paste values in a range | Excel Programming | |||
| copy and paste values in a range | Excel Programming | |||
| Use a button to copy the values of one range to another | Excel Programming | |||
| Out of Memory on simple range copy! | Excel Programming | |||
| Range COPY function - how to copy VALUES and not formulas | Excel Programming | |||
Linear Mode
