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:
the Variable LengthNAAMS is set as a 'Long" (I have tried it as a string and I get the same error.)Please Login or Register to view this content.
Right now it says Type Mismatch Error
But if I change it to:
It changes to Invalid Qulifer Error.Please Login or Register to view this content.
I have also tried this:
But the error I get then is object variable or With Block variable not set.Please Login or Register to view this content.
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
Bookmarks