Application Defined Error

[allenjasonbrown@gmail.com]

Hi - I have a procedure which is writing to excel. It calls a sub procedure to sort the data.



The code for sorting start with...

For Each row in xlSheet.Range(xlsheet.Cells(datastartrow + (( v-1) ..............

This all works great.

BUT....If I call a different sub routine and then try and call the sorting routine from there I get an Application defined error.


Anyone know why I can call the sorting procedure from the main routine but not a sub routine?

Thanks in advance.

[June7]

Would have to examine all relevant code. If you want to provide db, follow instructions at bottom of my post.

[Mahendra1000]

As June7 suggested please post a copy of your db for better understanding