LinkBack URL
About LinkBacks
Hi
Is it possible to have a macro to check the entire column Q for 0 (this is a number 0)
and if it is present, it stops the macro?
Hi
Is it possible to have a macro to check the entire column Q for 0 (this is a number 0)
and if it is present, it stops the macro?
something like this
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Thanks Mike
Unfortunately it is not working.
This is what my current macro do (bold is what i need in a macro):
1. Open .CSV file
2. Check Column Q for the value 0 (it will either have a two letter in a cell or a value 0)
3. Stop Macro if there is a value 0
4. If no value = 0, continue with the rest of the macro
Would this work?
Columns("Q:Q").Select
If Cells.Value = 0 Then GoTo SubErr
Try this
Please Login or Register to view this content.
Still doesn't work.
How about
If column Q contain 0 go to end of macro?
Whats doesnt work If there is a 0 in column Q the macro will stop?
Stop at zero.xlsm
If you want to stop the sub use Exit sub instead of Exit For
Last edited by mike7952; 10-06-2012 at 12:40 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks