Target Error

[samarbac]

HI
I'm constantly getting error when applying this code or sometime it doesn't even work. where am I going wrong ?

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

You can't compare an array to a single value.

[samarbac]

Please Login or Register  to view this content.

You can't compare an array to a single value.

Ah ok thanks
What would b the best way to make those codes work.

[shg]

I don't know what you're trying to do.

[Marc L]

Hi !

where am I going wrong ?

• Remove codelines On Error …
  
  
• Check the syntax where occurs any error …

[TMS]

You could maybe use CountA to test the range.

https://support.office.com/en-gb/art...2-53f3219e2509

[Rick Rothstein]

Please Login or Register  to view this content.

A suggestion... do not include space characters after your commas for long list arguments for the Range object... while you haven't reached it here (you are not too far off either, and who knows if you might want to extend the list in the future), the maximum length text string argument that can be passed into the Range object is 255 characters (or maybe it's 256, I can never remember which) and all those spaces do is take up valuable space (the spaces are not needed or used by the Range object when evaluating the passed in text string argument).