If Else problem

[NatalieW12]

Hi Again,

I am having trouble with the code below, I think it's the part were I'm trying to check the what is in the 2 cells, but not really sure.

If someone can point me in the right direction that would be greatly appreciated.

I'm getting this error with this code.

Runitime error ‘13’:
Type mismatch


Thanks
Nat

Please Login or Register  to view this content.

[nigelog]

Check quote there

Please Login or Register  to view this content.

[nigelog]

you also have range dimmed as variable rather than range, in this instance remove it

[TMS]

Remove "Dim Range" and try:

Please Login or Register  to view this content.

[NatalieW12]

Thank you all,

Removing the Dim Range and adding an extra End If at the end did the trick.

Thanks

[TMS]

You're welcome.