Passing Variable in Rows() function

[RiderJon]

Hi:

I am just starting with excel macros - so bear with me.

How do I pass a variable to reference rows.

for example I have

Dim Last1 As Integer
Last1 = 12

Rows("1:Last1").RowHeight = 15

But it gives an error in the Rows("1:Last") .....

RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave

 

[ETID]

try this....

Rows("1:" + CStr(last1)).RowHeight = 25

 

[ETID]

oops...
you only want 15

Rows("1:" + CStr(last1)).RowHeight = 15

 

[RiderJon]

wonderful. Thanx ETID.

RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave