Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

odd or even

Status
Not open for further replies.
wmbb

wmbb

Technical User
Jul 17, 2005
320
NL
How do I check if row number of the selected cell in excel is odd or even ?
 
Sort by date Sort by votes
a starting point:
Code: 
If ActiveCell.Row Mod 2 Then
  MsgBox "active row is odd"
Else
  MsgBox "active row is even"
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Thnx, this works perfect !
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

foxup
  • Locked
  • Question
CDO TLS or SSL
Replies
1
Views
406
foxup
foxup
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
905
remeng
remeng
feipezi
  • Locked
  • Question
How to detect dups and/or sum by group?
Replies
1
Views
241
Andrzejek
Andrzejek
TheAceMan1
  • Locked
  • Question
Detect if Ribbon Minimized or Maximized 1
Replies
2
Views
479
TheAceMan1
TheAceMan1
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
660
huiettcm
huiettcm

Part and Inventory Search

Sponsor

Back
Top