Changing Range

[zplugger]

Got some Great help today on a project from a member here,I would like to change the range that it checks. Having no luck,so I'm doing something wrong.

Good Code

Please Login or Register  to view this content.

Not working Code

Please Login or Register  to view this content.

Trying to get it to check any cell in that range?

[alansidman]

Please Login or Register  to view this content.

If I am understanding your request. Seems strange what you are trying to do. Perhaps, you should explain in simple English if this is not what you are after.

[zplugger]

Thanks Alansidman
Run time error 438, this line is yellow in the code
If Sheets("60 Circuits").c.Value <> "" Then

I will play around with this,I understand how you did it, Nice

[alansidman]

Try removing ".value"

[zplugger]

No luck, maybe this can't be done.

[alansidman]

Tell us in simple language what you want to achieve. It may be we are attacking it the wrong way.

[jolivanes]

Maybe

Please Login or Register  to view this content.

[zplugger]

Great suggestion jolivanes, it worked PERFECT. Lot of Great minds on this forum.

Thanks Everyone

[jolivanes]

Glad it works for you.
Good luck and thanks for the kind words.