Hello,
I have a problem in a bit of code that I just can't figure out. I need a code to loop through Q7:Q40 and if the value in a cell is 1, change the row color to blue (index 3).
In this bit of code:
Please Login or Register to view this content.
I keep getting a Run-time error '13': Type Mismatch. I have tried this in many different ways and I keep getting that error for that line.Please Login or Register to view this content.
Sometimes when I get an error like that I change .Value to . Text (or vice versa) and it corrects the error.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
That worked! So strange...
I wound up changing the code to this:
Thanks!Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
try something like this..
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Glad it worked for you. You might want to give TMS's solution a try as well, he's pretty good at this stuff.
I can't duplicate the error, but one thing to mention on my machine index 3 is red.
Could probably do with seeing some sample data (in a sample workbook). I'd especially like to see the expected outcome mocked up.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks