一、Application全部属性
Application.ActivateMicrosoftApp
Application.ActiveCell
Application.ActiveChart
Application.ActivePrinter
Application.ActiveSheet
Application.ActiveWindow
Application.ActiveWorkbook
Application.AddChartAutoFormat
Application.AddCustomList
Application.AddIns
Application.AlertBeforeOverwriting
Application.AltStartupPath
Application.AnswerWizard
Application.Application
Application.AskToUpdateLinks
Application.Assistant
Application.AutoCorrect
Application.AutoFormatAsYouTypeReplaceHyperlinks Application.AutomationSecurity
Application.AutoPercentEntry
Application.AutoRecover
Application.Build
Application.Calculate
Application.CalculateBeforeSave
Application.CalculateFull
Application.CalculateFullRebuild
Application.Calculation
Application.CalculationInterruptKey Application.CalculationState
Application.CalculationVersion
Application.Caller
Application.CanPlaySounds
Application.CanRecordSounds
Application.Caption
Application.CellDragAndDrop
Application.Cells
Application.CentimetersToPoints
Application.Charts
Application.CheckAbort
Application.CheckSpelling
Application.ClipboardFormats
Application.Columns
Application.COMAddIns
Application.CommandBars
Application.CommandUnderlines
Application.ConstrainNumeric
Application.ControlCharacters Application.ConvertFormula Application.CopyObjectsWithCells Application.Creator
Application.Cursor
Application.CursorMovement Application.CustomListCount Application.DataEntryMode Application.DDEAppReturnCode Application.DDEExecute Application.DDEInitiate Application.DDEAppReturnCode Application.DDEPoke
Application.DDERequest Application.DDETerminate Application.DecimalSeparator Application.DefaultFilePath Application.DefaultSheetDirection Application.DefaultSaveFormat Application.DefaultWebOptions Application.DeleteChartAutoFormat Application.DeleteCustomList Application.Dialogs
Application.DisplayAlerts Application.DisplayClipboardWindow Application.DisplayCommentIndicator Application.DisplayExcel4Menus Application.DisplayFormulaBar Application.DisplayFullScreen Application.DisplayFunctionToolTips Application.DisplayInsertOptions Application.DisplayNoteIndicat
or Application.DisplayPasteOptions Application.DisplayRecentFiles Application.DisplayScrollBars Application.DisplayStatusBar Application.DoubleClick Application.EditDirectlyInCell Application.EnableAnimations Application.EnableAutoComplete Application.EnableCancelKey Application.EnableEvents Application.EnableSound Application.ErrorCheckingOptions Application.Evaluate
Application.Excel4IntlMacroSheets Application.Excel4MacroSheets
Application.ExecuteExcel4Macro Application.ExtendList
Application.FeatureInstall Application.FileConverters Application.FileDialog
Application.FileFind
Application.FileSearch
Application.FindFile
Application.FindFormat
Application.FixedDecimal Application.FixedDecimalPlaces Application.GenerateGetPivotData Application.GetCustomListContents Application.GetCustomListNum Application.GetOpenFilename Application.GetPhonetic Application.GetSaveAsFilename Application.Goto
Application.Height
Application.Help
Application.Hinstance
Application.Hwnd
Application.IgnoreRemoteRequests Application.InchesToPoints Application.InputBox
Application.Interactive Application.International Application.Intersect
Application.Iteration
Application.LanguageSettings Application.Left
Application.LibraryPath Application.MacroOptions Application.MailLogoff
Application.MailLogon
Application.MailSession Application.MailSystem
Application.MapPaperSize Application.MathCoprocessorAvailable Application.MaxChange
Application.MaxIterations Application.MemoryFree
Application.MemoryTotal Application.MemoryUsed
Application.MouseAvailable Application.MoveAfterReturn Application.MoveAfterReturnDirection
Application.Name
Application.Names
Application.NetworkTemplatesPath Application.NewWorkbook Application.NextLetter Application.ODBCErrors Application.ODBCTimeout Application.OLEDBErrors Application.OnKey
Application.OnRepeat Application.OnTime
Application.OnUndo
Application.OnWindow Application.OperatingSystem Application.OrganizationName Application.Parent
Application.Path
Application.PathSeparator Application.PivotTableSelection Application.PreviousSelections Application.ProductCode Application.PromptForSummaryInfo Application.Quit
Application.Range
Application.Ready
Application.RecentFiles Application.RecordMacro Application.RecordRelative Application.ReferenceStyle Application.RegisteredFunctions Application.RegisterXLL Application.Repeat
Application.ReplaceFormat Application.RollZoom Application.Rows
Application.RTD
Application.Run
Application.SaveWorkspace Application.ScreenUpdating Application.Selection Application.SendKeys Application.SetDefaultChart Application.Sheets
Application.SheetsInNewWorkbook Application.ShowChartTipNames Application.ShowChartTipValues Application.ShowStartupDialog
Application.ShowToolTips
Application.ShowWindowsInTaskbar Application.SmartTagRecognizers Application.Speech
Application.SpellingOptions
Application.StandardFont
Application.StandardFontSize
Application.StartupPath
Application.StatusBar
Application.TemplatesPath
Application.ThisCell
Application.ThisWorkbook
Application.ThousandsSeparator
Application.Top
Application.TransitionMenuKey
Application.TransitionMenuKeyAction Application.TransitionNavigKeys Application.Undo
Application.Unionvba排序函数sort用法
Application.UsableHeight
Application.UsableWidth
Application.UsedObjects
Application.UserControl
Application.UserLibraryPath
Application.UserName
Application.UseSystemSeparators Application.Value
Application.VBE
Application.Version
Application.Visible
Application.Volatile
Application.Wait
Application.Watches
Application.Width
Application.Windows
Application.Windows.Count  '举例Application.WindowsForPens
Application.WindowState
Application.Workbooks
Application.WorksheetFunction
Application.WorksheetFunction.IsText  '举例Application.Worksheets
Application.Worksheets.Add    '举例
二、thisworkbook全部属性四、range全部属性With ThisWorkbook With Range("a1")
.AcceptAllChanges.Activate
.AcceptLabelsInFormulas.AddComment
.Activate.AddIndent
.ActiveChart.Address
.
ActiveSheet.AddressLocal
.AddToFavorites.AdvancedFilter
.Application.AllowEdit
.AutoUpdateFrequency.Application
.AutoUpdateSaveChanges.ApplyNames
.BreakLink.ApplyOutlineStyles .BuiltinDocumentProperties.Areas
.CalculationVersion.AutoComplete
.CanCheckIn.AutoFill
.ChangeFileAccess.AutoFilter
.ChangeHistoryDuration.AutoFit
.ChangeLink.AutoFormat
.
Charts.AutoOutline
.CheckIn.BorderAround
.Close.Borders
.CodeName.Calculate
.Colors.Cells
.CommandBars.Characters
.ConflictResolution.CheckSpelling
.Container.Clear
.CreateBackup.ClearComments
.Creator.ClearContents
.CustomDocumentProperties.ClearFormats
.
CustomViews.ClearNotes
.Date1904.ClearOutline
.DeleteNumberFormat.Column
.DisplayDrawingObjects.ColumnDifferences .EnableAutoRecover.Columns
.EndReview.ColumnWidth
.EnvelopeVisible.Comment
.Excel4IntlMacroSheets.ColumnWidth
.Excel4MacroSheets.Comment
.ExclusiveAccess.Consolidate
.FileFormat.Copy
.FollowHyperlink.CopyFromRecordset .ForwardMailer.CopyPicture
.
FullName.Count
.FullNameURLEncoded.CreateNames
.HasPassword.CreatePublisher
.HasRoutingSlip.Creator
.HighlightChangesOnScreen.CurrentArray

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。