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
Dim CellPtr As Long For CellPtr = 1 To Cells(Rows.Count, "Q").End(xlUp).Row If Cells(CellPtr, "Q").Value = 0 Then Exit For Next End Su
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
Dim CellPtr As Long For CellPtr = 1 To Cells(Rows.Count, "Q").End(xlUp).Row If Cells(CellPtr, "Q").Value = "0" Then Exit For Next End Sub
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