Range Select

[matt_Gill]

Hey guys,

I'm currently writing a program the has writes a variable number of answers determined by the user. I have a count which tells me how many numbers there are, i have to graph these the problem is how do i select a range of using the count value.

At the moment its
Range("B3:B42").Select

I wish for it to select B3:Bcount, how do i do this?

advance thanks

[Simon Lloyd]

Range("B3:B" & Range("B" & rows.count).end(xlup).row)