Hello,
Im wondering if theres away to add a named range to a specified sheet
without selecting that sheet first. I can get a row count from a sheet while
its not active€¦

Public MASTERwb As Workbook

Sub ScaleVLU()
Dim RowCnt As Integer

Set MASTERwb = ActiveWorkbook
MASTERwb.Sheets(€œabc€�).Select
RowCnt = MASTERwb.Sheets(€œabc€�).UsedRange.Rows.Count
MASTERwb.Names.Add Name:="VLU", _
RefersTo:="=" & MASTERwb.Sheets(€œabc€�).Range("A1:D" & RowCnt).Address
End Sub

Appreciatively,
Arturo