Custom Views

ppleasebob

Board Regular
Joined
Dec 23, 2002
Messages
145
Is it possible to name a custom view based on a cell value, by VB, and if it is, can I recall that custom view by lookup?

This will dictate how I build the rest of my spreadsheet, thanks for looking

bob
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,523
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Yes - you can use the value of a range as the name (as long as it's valid) when using CustomViews.Add in code. Equally, you could then recall it from a table in code.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,314
Members
409,862
Latest member
lbisacca
Top