Bob Phillips wrote

Declare them as public variables, before any macro, in a standard code
module

Public NumRows as Long
Public NumCols as long


Sub macro1(0
...
End Sub

Ok, so how would each Sub know those were referring to my named range?
Range("Name_Copy").Rows/Columns.Count

Be easy, this is brand new to me.

--
David