Get Names of ActiveWorkbook.CustomViews
 

How can I collect the names of all the defined custom views?

TIA,

Phil

Get Names of ActiveWorkbook.CustomViews
 

this may help you get what you want

Sub test()
Dim i As Long
For i = 1 To ThisWorkbook.CustomViews.Count
MsgBox ThisWorkbook.CustomViews(i).Name
Next
End Sub

--


Gary


"cellist" wrote in message
...
How can I collect the names of all the defined custom views?

TIA,

Phil

Get Names of ActiveWorkbook.CustomViews
 

Thanks Gary. That's exactly what I need.

"Gary Keramidas" wrote:

this may help you get what you want

Sub test()
Dim i As Long
For i = 1 To ThisWorkbook.CustomViews.Count
MsgBox ThisWorkbook.CustomViews(i).Name
Next
End Sub

--


Gary


"cellist" wrote in message
...
How can I collect the names of all the defined custom views?

TIA,

Phil