Hello all,
Firstly, I hope your all SAFE.
I am having problems with loading "Products" from the Products_DB (Sheet 3) onto Products_Control (Sheet 12) when I use the this:
Sheet 12 Code-
When I enable the Sheet 12 Worksheet_Change Code the Application seem to run into a snags. For instance, when I click into a cell with the Table "tblProduct_DB" doe not show in the Table Name block in the Design Tab. It does show up when I use the dropdown in the Named Ranges area in the Formula Bar.Please Login or Register to view this content.
When I run the code the code below on it's own it seem to run fine without the Sheet 12 Worksheet_Change. I'm attempting to incorporate the use of Tables and Structured References in my named ranges.
Sheet 3 Code
Please Login or Register to view this content.
Thank you in advance for your assistance.
V/r,
Jim
Bookmarks