If statement if cell is between 2 rows? [Beginner]

[distiDoestoe]

Hi, I'm very new to VBA and I want to make an if statement is the selected cell is between two rows (between 6, 10 as an example).
Only I can't figure it out, I'm used to more different types of programming languages (Python, PHP, JavaScript) and with those I never really had issues but VBA I find very hard to learn / find a fix to problems.
I hope maybe someone can pinpoint me to the right direction. (And maybe some tips on where to learn more, like the W3schools for VBA...)

 

[hrayani]

Hello,

This code will show you a message box if the current cell is between row 6 & 10
You can change the show message box to whatever you want

Sub findrow()
If ActiveCell.Row > 5 And ActiveCell.Row < 11 Then MsgBox "hello world"
End Sub

 

[distiDoestoe]

Thank you, I didn't realise it could be this simple

Hello,

This code will show you a message box if the current cell is between row 6 & 10
You can change the show message box to whatever you want

Sub findrow()
If ActiveCell.Row > 5 And ActiveCell.Row < 11 Then MsgBox "hello world"
End Sub

 

[hrayani]

Thank you, I didn't realise it could be this simple

You're welcome

 

[hrayani]

I didn't realise it could be this simple

This is just for your information - You can also write it as below

If ActiveCell.Row >= 6 And ActiveCell.Row <= 10 Then MsgBox "hello world"

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

If statement if cell is between 2 rows? [Beginner] - OzGrid Free Excel/VBA Help Forum

Hi, I'm very new to VBA and I want to make an if statement is the selected cell is between two rows (between 6, 10 as an example). Only I can't figure it out, I'm used to more different types of programming languages (Python, PHP, JavaScript) and with…

forum.ozgrid.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.