In Range Replace (Excel2003)

Topic

New Reply

I have
Range(“A1:AH15”).Select
where 15 is a result of a function
RowsNum = Selection.CurrentRegion.Rows.Count
where RowsNum = 15

How do I make Range(“A1:AH15”).Select
where 15 will be a variable that will take RowsNum’s value?

Thanks much

Reply | Quote

Replies

Range(“A1:H” & RowsNum).Select

Reply | Quote

Awesome as always
Thanks HansV

Reply | Quote