Problem define range for multiple sheets
I'm not real clear on what you are trying to do, but you don't have to
activate or select Sheet2 in order to hide some rows on it.
Sheets("Sheet2").Range("ptrMinMaxWageScale", _
Range("ptrMinMaxWageScale").Offset(-lRowsCount, 0)) _
.EntireRow.Hidden = True
Hth,
Merjet
|