Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
make a named range with an array not using a workseet cell range
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="GS, post: 6454310"] It happens that John S. formulated : Validation lists must be a delimited list OR a reference to a range that contains a list. If you want to add Validation for a specific list to any cell then this might be the way to go... With Selection.Validation .Delete .Add Type:=xlValidateList, _ AlertStyle:=xlValidAlertStop, _ Formula1:="Mon,Tue,Wed,Thu,Fri,Sat,Sun" .IgnoreBlank = True: .InCellDropdown = True .ShowInput = True: .ShowError = True End With [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
make a named range with an array not using a workseet cell range
Top
