Private Function within class module/object, can't pass value of range as string

You would use Set in conjunction with objects. The return value is a string therefore uses Let instead. And Let is optional.

Why do you think you should, or want to, be using Set?

I don't get that error with your files (after removing the Set). I do note though that you never check to see if your Find operations succeeded before using the found cell, which is bad practice.

Also note that code like this can fail:

Please Login or Register  to view this content.

It needs to be:

Please Login or Register  to view this content.

Originally Posted by rorya

I don't get that error with your files (after removing the Set). I do note though that you never check to see if your Find operations succeeded before using the found cell, which is bad practice.

Removing set get generates error 91 on my end.

Please Login or Register  to view this content.

I use the the debugger, and soruceVehCell is pointing to the correct cell that holds the value, and vba is refusing to pass the value to the string variable. Sheet3 shows what Sheet2 is supposed to look like.

I the following file (attached to this post), I'm able to assign to do extractOrginalSourceVehNum = sourceVehCell.Offset(, 1).Value, without that error message.

I even got rid of "As String", in the initial spreadsheet I uploaded, and the same problem still occurs.

As stated, this function and it's result is meant to be only called within the class module, not outside of it.

I went ahead and implemented property let and property get

Please Login or Register  to view this content.

And I'm getting the same error message, but in a different function

Please Login or Register  to view this content.

I think I found the cause.

In the ClassIntialize Function, I needed to reposition a Property Let/Get function, i.e. exportFileName(expFilePrefixStr) = vehNum

to below the sourceVehCell_vehNum = extractOrginalSourceVehNum initialization, since the former was calling a function, dependent on the result from the initialization of sourceVehCell_vehNum.

The debugger was displaying a sourceVeh number that was non-existent in Column A.