LinkBack URL
About LinkBacks
Hi.
The macro code below will exit if the user selects any column other than column A.
Can anyone add to the code that if the user selects an even row in column A that the code will exit as well?
Thank you.
If ActiveCell.Column <> 1 Then Exit Sub
Hi.
The macro code below will exit if the user selects any column other than column A.
Can anyone add to the code that if the user selects an even row in column A that the code will exit as well?
Thank you.
If ActiveCell.Column <> 1 Then Exit Sub
If ActiveCell.Column <> 1 Then Exit Sub ElseIf Activecell.column = 1 and Application.IsEven(ActiveCell.Row) Then Exit Sub End If
Last edited by Solus Rankin; 04-03-2014 at 01:30 PM.
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."
thank you but the code didn't exit whether I landed on an even row or odd row
Hi, kosherboy,
Ciao,With ActiveCell If .Column = 1 Then If (.Row Mod 2 = 0) Then Exit Sub Else Exit Sub End If End With
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
HaHoBe, thank you! It worked!
Best of luck.
Hi, kosherboy,
Ciao,With ActiveCell If .Column = 1 And (.Row Mod 2 = 0) Then Exit Sub End With
Holger
thanks hahobe the code works when I'm on column A but when I am on column B the code doesn't work or better yet the code doesn't exit sub.Originally Posted by HaHoBe
Hi, kosherboy,
Ciao,With ActiveCell If .Column = 1 And (.Row Mod 2 = 0) Then Exit Sub End With
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks