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...This all works great.Code:For Each row in xlSheet.Range(xlsheet.Cells(datastartrow + (( v-1) ..............
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.