Hey Everyone for some reason im getting a next without a for error in the debug for this code:
I was trying to practice with some things I learned from on of the forum experts but im not sure why im getting this error (or if the variables I have set for cost will work) trying o have it search for currency values
Please Login or Register to view this content.
Thanks as always to those greater and wiser than I
Fawkes_
Your 4th If statement is missing an End If.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Alright, totally missed that smh, one day ill stop missing the small stuff.
I have once more question if anyone has a moment.
Im trying to highlight anything that falls into the array red, which works, im trying to highlight any value between 5000 and 9999.99 as yellow it works, but when I add the portion to highlight any value over 10,000 as red it just highlights the entire sheet.
Please Login or Register to view this content.
Actually, I think the problem lies in the cost variables im setting, the column it is searching is using the output from an equation to make a currency value.
and I don't know how to make my ranges work properly.
I uploaded a template with an example of what im talking about anyone have any ideas?
Last edited by Fawkes_; 02-08-2017 at 06:15 PM.
Update, I was trying a few different things as well.
All are failing, Anyone have any ideas?Please Login or Register to view this content.
Define the variables as double.... not string, then set their value without quotes. Also the arrray should not be strings. The column you are checking is numerical.
Last edited by Arkadi; 02-09-2017 at 04:30 PM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Which method would I use to set them?
Please Login or Register to view this content.
Set is for objects like ranges, normal variables(string, double, long, integer, etc) don't use "Set" just "costY = 5000"
Lol, so simple.... you make it all look so easy my good man thank you as always
My pleasure to help you out my friend
I must ask once again though .. If this is resolved please mark the thread as solved? It is important to keep the site running well that people help us with these details. Thanks
Originally Posted by Arkadi
My pleasure to help you out my friend
I must ask once again though .. If this is resolved please mark the thread as solved? It is important to keep the site running well that people help us with these details. Thanks
Sorry, the site tripped out after my last post to you and I couldn't get logged in again to close it. 🤦*♂️ is there a way to close if on mobile?
Yeah there have been some issues, it is being worked on as far as I know.
Thanks for taking care of it
Not sure about the mobile... unless you change the theme from mobile to regular (option at the bottom when viewing on mobile)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks