Ask code if ActiveCell.Row is within a range

[williekay]

How do you ask the following in VBA

Is ActiveCell.Row between 5 and 10?

Willie

 

[SkipVought]

hi,

Avoid Active anything as a reference in general.

if not intersect(activecell, rows("5:10")) is nothing then
  'houston, we have a hit
end if

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}