Function returning error

Hi all,

I have a function that works out which is the last column containing data on a worksheet, but for some reason it is alwys retuning 0. Just wondering if anybody is able to spot where I am going wrong.

Here is the function I am using -

Please Login or Register  to view this content.

And here are the ways I have tried retrieving data from the function, all of which return 0 -

Please Login or Register  to view this content.

When I take the Error handleing out I am getting the error 'Object Variable or With Block Variable not set'. All variables are correctly declered.

Any help is greatly appriciated.
Thanks.

If I leave the error handlers in the Function, noting happens, but LastColumn is returned as 0 (as set if 'Error <> 0'). But if I remove that that I get an error (Run-time error '91';, which is the one mentioned above) the first time I go into the meat of the function.

I do indeed have data (Far to much if you ask me!!), I have checked that 'wS22' is the currently selected sheet, and the the correct workbook is selected, but still no joy

They are both the same, but I have also tried to manually assign the name of the sheet to a variable and then checked using the variable as the sheet name, but still get 0 returned.

Hmm, thats random. The function is located at the bottom of a Module called 'Functions'. I have tried to run the function from both inside and outside the Module that contains it, using both public and local variables, each time I get '0' returned.

This may be completely wrong, but as it is declared as a Public Function, it should matter where it is located, should it?

Ah, Ok. Do you mean have I used Find at any other point in the code? If yes, then no, this is the only occurance of it.

You'll have to excuse my noobness here, but what is 'UI', and how would I override the setting in the code?

Well, I do have a couple of Forms that are used before this function is called, but neither of them use Find at all. I have specified every paramiter for find and I am still getting 0! I am going to scratch my head for the night and come back to this tomorrow. Thanks for the help up til now.

I cheated in the end and went for this, as it is only going to be used once in the code. Thanks for your help.

Please Login or Register  to view this content.