wagnet
05-03-2006, 09:03 AM
Is there a way to determine what variables are currently set in VBA, their format, and their current value?
I'm running VBA code written by someone else and I'd like to be able to "trap" the above information & record the variable settings to a worksheet:help ....something like:
x = 1
r = 1
Do
Cells(r,1) = Variable(x).Name
Cells(r,2) = Variable(x).Format
Cells(r,3) = Variable(x).Value
r = r + 1
Loop Until x => ???
I'm running VBA code written by someone else and I'd like to be able to "trap" the above information & record the variable settings to a worksheet:help ....something like:
x = 1
r = 1
Do
Cells(r,1) = Variable(x).Name
Cells(r,2) = Variable(x).Format
Cells(r,3) = Variable(x).Value
r = r + 1
Loop Until x => ???