Trouble using 'Is Not Nothing'

**EverGreen1231** · 01-22-2016, 10:49 AM

I have a spreadsheet I'm trying to automate (I find that once people find out you can do that type of thing, they have more for you to do

). I have the code below. When I run the code, it returns a 'Compile Error: Invalid Use of Argument' and highlights the 'Is Not Nothing' portion of my conditional statement. I asked google what it thought about this, but it wasn't giving me much that was helpful.

I would be grateful if someone could point in the direction of an answer to this problem. Thank you.

Here's the code...

Please Login or Register  to view this content.

**zbor** · 01-22-2016, 10:50 AM

Try

Please Login or Register  to view this content.

**Norie** · 01-22-2016, 10:51 AM

If CurrentLineName was an object you would use Not CurrentLineName Is Nothing, but since it isn't an object you wouldn't use Nothing.

Try using CurrentLineName<>"".

**EverGreen1231** · 01-22-2016, 10:55 AM

Originally Posted by zbor

Try

Please Login or Register  to view this content.

That works, thank you. I've run into the problem I mentioned above several times and usually use some other method to circumvent it.

Originally Posted by Norie

If CurrentLineName was an object you would use Not CurrentLineName Is Nothing, but since it isn't an object you wouldn't user Nothing.

Try using CurrentLineName<>"".

Well, I suppose that would make sense.