Find Excel Ranges in VBA

[Adamba]

Hiya all

Im trying to write some code which will tell me how many products are within a selected range which is defined by the user.

I can easily loop through all the records in a sheet to find out whether they match my criteria but am struggling with pulling out just a certain range as i do not how to recieve the first and last row highlighted by a user.

Is there anyway i can pull off the first and last row which are highlighted by the user as activecell.row only pulls out the 1 white cell.

Thanks in advance
Adam

 

[Loomah]

hi adam
you could try this

Sub SomeRows()
Dim lRowOne As Long
Dim lRowTwo As Long
With Selection
lRowOne = .Rows.Row
lRowTwo = .Rows.Row + .Rows.Count - 1
End With
End Sub

seems to work on a single range no matter where the active cell (white one!) is

2 days to go
;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[Adamba]

Loomah,

Thanks!
After hours/days/months/years of work and its 4 lines!

lol, ohh well that'll teach me to try and find a complicated way of doing it

Thanks again!
Adam