フィルターのクリア

Does setting Data Validation work with Excel actxserver

6 ビュー (過去 30 日間)
Dave Watson
Dave Watson 2015 年 10 月 19 日
編集済み: Dave Watson 2015 年 10 月 19 日
Has anyone got this to work from a program? I have tried the statement below in a program (100% failure), from the command line (~90% success), and in the debugger (~50% success). I have tried putting a .Delete call in first and have tried a .Modify call instead of the .Add?
Thanks.
hs is a Range object; ProType is a defined name in the workbook (which is workbook scope) and is defined as a range on a sheet. K>> hs.Range(dRange).Validation.Add(3, 1, 1, '=ProType') Error using Interface.Microsoft_Excel_14.0_Object_Library.Validation/Add Error: Object returned error code: 0x800A03EC

回答 (0 件)

カテゴリ

Help Center および File ExchangeUse COM Objects in MATLAB についてさらに検索

製品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by