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