Use this forum for any general discussion and questions about Excel
Posts: 1
Joined: Thu Apr 18, 2019 6:21 pm


Postby OleanderG » Thu Apr 18, 2019 6:33 pm

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 ?


Posts: 274
Joined: Tue Sep 09, 2014 8:13 am

Re: "ThisWorkbookDataModel"

Postby PhilC » Tue May 14, 2019 3:41 pm

Return to “Excel”

Who is online

Users browsing this forum: No registered users and 1 guest