Page 1 of 1

"ThisWorkbookDataModel"

Posted: Thu Apr 18, 2019 6:33 pm
by OleanderG
HI
I have a search page that trough VBA are looking in a database "DATA" that is aggregated from the Datamodel "Merge1" in a table that are within a perimeter of
"Set MyRange = Range("Data!A:AE")"

I want to use the datamodel directly instead but I do not know how to adress this in the "Set MyRange", I've tryed with

"Set MyRange = Range("ThisWorkbookDataModel","Merge1")
but that doesn't help.

Is there someone that can guide me how to solve this issue ?

G

Re: "ThisWorkbookDataModel"

Posted: Tue May 14, 2019 3:41 pm
by PhilC