By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (34 of 1182)

(Clear Filter = *Application*)

application.statusbar =
Application.CutCopyMode = False - gets rid of crawling ants
application.evaluate(sLookup) - runs a vlookup or match or other excel statemnt
Application.EnableEvents = False
Application.Calculation = xlCalculationManual ' recorded
Application.ScreenUpdating = True/False ' used for optimization
Application.Calculation = xlCalculationAutomatic ' optimization
Application.DisplayAlerts = False ' get rid of unneeded dialog box
Application.Height
Application.width
Application.Left
center in excel - application.width / 2
as Outlook.Application
As Word.Application
set wrdApp = CreateObject("Word.Application")
Application.IgnoreRemoteRequests
Application.CalculateFull ' recorded
Dim PPT As Powerpoint.Application
Set PPT = CreateObject("Powerpoint.Application")
Set PPApp = GetObject(, "Powerpoint.Application")
Application.AskToUpdateLinks = false
Application.Calculate
Application.Ontime Dateadd("n",30, Now(),"Sub_to_run_name" ' i
Application.Evaluate("=vlookup(""" & ..... & """,'" & from ....
Application.EnableEvents = True/False
Application.Caption
Application.Run - can be used to run a passed function on parameters - code in pptools - Callback_testing
Application.OnKey
Application.ErrorCheckingOptions.BackgroundChecking = False ' recorded optimize
Application.Autocorrect ' record
WorksheetFunction.Min( ) I use application.evaluate
Application.WindowState = xlMaximized - recorded
Application.WindowState = xlNormal - recorded
Quit Excel- Application.Quit
Top