Microsoft Office Forums - View Single Post - [Solved] Workbook data Names in VBA are string only?

Thread: [Solved] Workbook data Names in VBA are string only?

View Single Post

Old

01-28-2014, 07:06 AM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2010 32bit

Catalin.B uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

Hi Bob,
Have you tried this:

Code:

Application.Evaluate(ThisWorkbook.Names("SalPilot").RefersTo)

Or:

Code:

Application.Evaluate(ThisWorkbook.Names("SalPilot").Value)

Reply With Quote