I like to let excel do the heavy lifting...

Dim myRng as range
set myrng = activesheet.range("p2:p300")
....

... = myrng.address(external:=true)

------------
If you want to supply the string yourself:
... = "'" & activesheet.name & "'!p2:p300"

(Some names will require those apostrophes.)

"Patrick C. Simonds" wrote:

I have a UserForm with a ComboBox. The current RowSource for the ComboBox is
shown below. Is it possible to make the RowSource be the range $P$2:$P$300
of the active worksheet? I have 12 different worksheets that can call this
one UserForm.

'Names'!$P$2:$P$300

--

Dave Peterson