Rows(xx:xx).Select statement

[miche7]

I have a macro which runs from a button on worksheet "Index" to hide unused rows on other sheets in the same workbook. The code I need assistance with:

' Rows("BeginUnused:EndUnused&quot.Select
‘ This code works
Rows("5:99&quot.Select
Selection.EntireRow.Hidden = True

"BeginUnused" in cell Index!C12 and "EndUnused" in cell Index!D12 are variables. If "BeginUnused" should change to 46, for example, I currently have to manually edit the macro. How do I use cell references in the Rows(xx:xx).Select statement?

Any assistance is greatly appreciated.

Michele

 

[RobBroekhuis]

range(cells(range("BeginUnused&quot,1),cells(range("EndUnused&quot,1).entirerow.hidden=true

will do the trick. This assumes that the sheet on which the rows to be hidden reside is active, and that you have named ranges to refer to the cells on Index. If they are not named ranges but variables, use:

range(cells(BeginUnused,1),cells(EndUnused,1).entirerow.hidden=true

Rob

 

[xlbo]

Or
Rows(sheets("Index&quot.range("C12&quot.value & ":" & sheets("Index&quot.range("D12&quot.value).entirerow.hidden = true

or

BeginUsed = sheets("Index&quot.range("C12&quot.value
EndUsed = sheets("Index&quot.range("D12&quot.value

Activesheet.rows(BeginUsed & ":" & EndUsed).entirerow.hidden = true Rgds
Geoff

Si hoc legere scis, nimis eruditionis habes