Highlighting a range of cells in VBA

[brendang]

Hi,

I was hoping someone might be able to help regarding the following
query.
I am trying to write a macro that will, among other things, select a
group of cells depending on the value of a named cell.

The type of thing I am going is as follows:




Sub Macro2()


-----------
s = Range("ROWCOUNT").Value (value of which is 5)
t = Range("ROWCOUNT").Value (value of which is 15)
Range("(A & s)g & t)").Select


-----------
End Sub


This will give a runtime error 1004. Basically, I want to highlight
cells A5 to G15.

I would appreciate any help with this.
regards
Brendan.

 

[Dick Kusleika]

Brendan

Range("A" & s & ":G" & t).Select

Note that Range("ROWCOUNT").Value will not return both 5 and 15.