D
Dave Peterson
I would try stepping through the code.
Get everything set up the way you need--maybe on a smaller set of data that
fails.
Then go to the VBE and put your cursor somewhere inside that procedure and hit
F8.
F8 will step through each line of code. So you can see how the code gets run.
You'll want to look closely at this portion (if this is the final code):
Maybe the value v isn't numeric???
=======
ps. There is no such thing as Final code <vbg>.
Get everything set up the way you need--maybe on a smaller set of data that
fails.
Then go to the VBE and put your cursor somewhere inside that procedure and hit
F8.
F8 will step through each line of code. So you can see how the code gets run.
You'll want to look closely at this portion (if this is the final code):
Maybe the value v isn't numeric???
=======
ps. There is no such thing as Final code <vbg>.