convert a single-celll range to a cell

**jimredfield** · 12-28-2012, 03:27 PM

The code below generates a type mismatch error as shown. I think it's because 'Target' is a single-cell range, not a cell proper, so 'Target.Value' fails but I don't know how to convert the range to a cell. Help appreciated.

Please Login or Register  to view this content.

Thanks - Jim

Moderators Note: Please follow Forum Rule #3 and use code tags. Added this time, but please use them in the future…Thanks.

**OllieB** · 12-28-2012, 03:43 PM

Hi Jim,

The usage of Target.Value is correct in this context. Perhaps the compare against "" (which implies it is a string) is causing the problem?

You could try

Please Login or Register  to view this content.

i.e. LenB is the fastest way to check if a variable is empty

**AB33** · 12-28-2012, 03:45 PM

The Target.Value is looking for the Range("InputRange")) . What is in it? It looks like a named range. The code will trigger if the target and named range intersect

Please Login or Register  to view this content.

**Norie** · 12-28-2012, 03:58 PM

The If statement will only work if Target is one cell and doesn't have an error.

Please Login or Register  to view this content.

**jimredfield** · 12-28-2012, 06:43 PM

Thanks all for the quick help. Olaf, I couldn't your solution to work (continued to get mismatch errors); AB33, I didn't try your solution because Norie's solution (which I saw at the same time) was more desirable with respect to error catching and since it worked perfectly I never looked back. Again, thanks all. - Jim (Moderator, sorry about the lack of code tags.)