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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ask code if ActiveCell.Row is within a range

Status
Not open for further replies.
williekay

williekay

Technical User
Jun 30, 2003
121
0
0
US
How do you ask the following in VBA

Is ActiveCell.Row between 5 and 10?

Willie
 
Sort by date Sort by votes




hi,

Avoid Active anything as a reference in general.
Code: 
if not intersect(activecell, rows("5:10")) is nothing then
  'houston, we have a hit
end if


Skip,
[sub]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
224
SkipVought
S
morechocolate
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
309
morechocolate
morechocolate
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
124
mintjulep
M
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
93
strongm
strongm
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
141
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top