K
Karen53
Hi,
I am trying to set these as public constants so I don't have them retyped
all over the place. I use the same form and reset the RowSource depending on
what I'm doing. So, I wanted to set them in one place and use them as a
variable. This is what I tried
Public Const CAMExtLIRowSource As String =
"Worksheets(Replace(Tablespg.Name, """", "" ''"")).Range" & _
"(""CAMLineItemsExterior"").Address(external:=True)"
then I use it with .rowsource = CAMExtLIRowSource
I get an error "Could not set rowsource. Invalid Property Value"
Is it possible to do this?
I am trying to set these as public constants so I don't have them retyped
all over the place. I use the same form and reset the RowSource depending on
what I'm doing. So, I wanted to set them in one place and use them as a
variable. This is what I tried
Public Const CAMExtLIRowSource As String =
"Worksheets(Replace(Tablespg.Name, """", "" ''"")).Range" & _
"(""CAMLineItemsExterior"").Address(external:=True)"
then I use it with .rowsource = CAMExtLIRowSource
I get an error "Could not set rowsource. Invalid Property Value"
Is it possible to do this?