Range select

[Hawkide]

Excel 97

I have not adjacent data that I want to select. I have column and row numbers that define the range to select.

i.e.
Columns 2 and 7
Start row 3
end row 5


Based on the above, the selection should be:

Range("B3:B5,G3:G5").select

How can I create a VBA statement using the numeric values?

 

[johnwm]

Try these references:

faq222-2244
forum707

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

For tsunami relief donations

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts