I am looking at a Excel file that in
VB has Microsoft Excel Object that are
named like:
Siz01_Customer(CustomerName)
Siz02_Product(ProductName)
Below all of are the Sheets that I expected to see. Many of the Siz sheets
are blank or contain a limited amount of code, and in some cases the
SheetName I would expect to show up as:
Sheet1(PricingInfo) is showing up as: Siz03_Pricing(PricingInfo)
Questions:
(1) I have never seen this done before, how do you edit from "Sheet1" to
"Siz03_Pricing"?
(2) Is this a common practice or does/can this cause any type of reference
problems?
(3) How do you edit back to the SheetName?