PDA

View Full Version : Range Select



matt_Gill
10-09-2008, 06:56 PM
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
10-09-2008, 07:01 PM
Range("B3:B" & Range("B" & rows.count).end(xlup).row)