Hi,

I've built a ws for data storing (60 or so columns) and also I've
incorporated as if an audit trail. It works something like this - if a
value gets changed, it calls a procedure that passes variables
(oldVal, newVal) and calls auditTrail procedu

sub auditTrail (oldVal, newVal)

worksheets("AuditTrail").cells(x, oldVal_COL)=oldVal
worksheets("AuditTrail").cells(x, newVal_COL)=newVal

end sub

I haven't declared the variable (oldVal, newVal) types on purpose as
they can be anything from String, to Double, to Date.
And that's why my question - how should I grab the variables from the
calling procedure - either as
..value [gues not]
..text
..value2
or with just specifying range (i.e., without .value or .text etc.)?

I'm just concerned that i might run into errors of having March 12
treated as Dec 03 instead.

Any suggestions how these should be handled?
Thanks,