I have a loop set up to run a function. I need to be able to do some validation and if a cell is invalid it skips to the next loop. I have numerous error checks to do and should any of them be an error I want to skip to the next loop. I know its easy I just cant picture it
Thanks
Hi,
Well at its simplest you need to preface the loop..end loop instruction with an IF test on the cell which might be invalid. If the test is succesful then the loop will run, if not control will bypass the loop to the End If statement.
In order to advise more I think we need to see the workbook.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
can't you just perform each test and only run the code if all pass?
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Something like this:I could make it more precise if you wanted to attach your workbook.Please Login or Register to view this content.
Last edited by Solus Rankin; 07-23-2013 at 09:25 AM.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
This is what I have:
Please Login or Register to view this content.
What I want to do is ensure these cell are valid if they are run the function on that row, if their not skip to the next row
perhaps
Please Login or Register to view this content.
Hi Josie,
ive tried this but it doesn't work, if a letter is typed there is a miss match, and if a row is empty it doesn't complete the function
I don't fully understand how it works so couldn't try to alter it, if you could an explanation would be helpful
Thanks
my bad-had the resize method wrong
Please Login or Register to view this content.
Excellent thanks Josie that works
but what is this magic you have used ive never come across error handling like that and I could use it in a load of places.
Regards
Jim
that ain't magic ;-)
it just uses the COUNT worksheet function to make sure there are 4 numbers in the 4 cells and the COUNTIF function to make sure all 4 are greater than 0
Ah that makes sense I like the use of resize I shall certainly be using that one in the future
Thanks for your help
Ah that makes sense I like the use of resize I shall certainly be using that one in the future
Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks