Small Issue with Type Mismatch and Invalid Qualifier when setting variable value from cell

[TomToms]

Hello,

I am haveing a small issue I am trying to set a variables value based on the value of a cell in a row that was searched for. Heres my code:

Please Login or Register  to view this content.

the Variable LengthNAAMS is set as a 'Long" (I have tried it as a string and I get the same error.)

Right now it says Type Mismatch Error
But if I change it to:

Please Login or Register  to view this content.

It changes to Invalid Qulifer Error.

I have also tried this:

Please Login or Register  to view this content.

But the error I get then is object variable or With Block variable not set.


Not sure how to fix this. If the code doesn't make sense it is supposed to find a Value in Column F and set the variable "S" to that row than select the value of the 7 cell over in row "S" and set the Variable LengthNAAMS to the value of that cell.

Anything is helpful ! Even a whole new way of doing this

[romperstomper]

Close:

Please Login or Register  to view this content.

[TomToms]

Wow, so simple yet I still missed it... Thankyou so much