expertatexcel.com

Standard VBA/Excel (153 of 1182)

	•	a Order of learning
	•	a Order of Learning List
	•	a Excel/VBA for yourself vs. users of your sheets (18)
	•	a filename can't use certain characters line "/" so change it if creating it from data
	•	A01 CopyToDocumentumSweep - copies files to a network directory
	•	A01 CreateWorkspace - vba
	•	A01 Dim rsCOB As DAO.Recordset
	•	A01 Dim WshShell As Object
	•	A01 doc "text" ' udf documents the code
	•	A01 DocumentsPath = WshShell.SpecialFolders(16)
	•	A01 FormatforPrinting - udf - report engine
	•	A01 FormatFromTemplate - udf - Report engine complex
	•	A01 GTOD(e,offset, optional retDate) - udf Get Type of Date - c for Credit Studio, e for Everest
	•	A01 IsRating - determines if a field is a rating range returns true/false
	•	A01 vbLF
	•	Abs(x) ' math absolute value
	•	Abstraction - Chess means what? or any term table, chair
	•	AC - udf sc - Activecell
	•	Acronyms
	•	Active
	•	ActiveCell.Address
	•	Activecell.Column
	•	Activecell.formula
	•	Activecell.formulaR1C1 =
	•	Activecell.formulaR1C1 = "=If(RC[-32]=0,0,RC[-10]/RC[-32]
	•	Activecell.formulaR1C1 = .... - code from macro recorder
	•	Activecell.FormulatR1C1
	•	activecell.MergeArea
	•	Activecell.mergecells
	•	ActiveCell.Offset(1,0).Address
	•	ActiveCell.Offset(1,0).select
	•	Activecell.Row
	•	ActiveSheet.Buttons.Add(top,left,width,height).select 'not sure of the params
	•	ActiveSheet.ChartObjects(sFromAddr).Activate
	•	Activesheet.ChartObjects(sToAddr).Delete
	•	ActiveSheet.Copy After:=Workbooks(sMainWBK).Sheets(Sheets.count)
	•	ActiveSheet.Index - gets the sheets number (not sure why you'd use this
	•	ActiveSheet.name
	•	Activesheet.Names(sName).Delete ' deletes a named range
	•	ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 ' recorded
	•	Activesheet.paste
	•	Activesheet.PivotTables("PivotTable11").PivotFields("CtryOfDom").PivotItems ' recorded
	•	ActiveSheet.PivotTables("PivotTable3").ChangePivotCache ... ' recorded
	•	ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh ' recorded
	•	ActiveSheet.PivotTables("PivotTable3").PivotFields("Region").ClearAllFields 'recorded
	•	ActiveSheet.PivotTables("PivotTable3").PivotFields("Region").CurrentPage = sValue
	•	ActiveSheet.PivotTables("pt1").ColumnGrand = True ' recorded
	•	ActiveSheet.PivotTables("pt1").PivotFields("Acct_nbr").Autosort xldescending, sort ' recorded
	•	ActiveSheet.PivotTables("pt1").PivotFields("coper_id").PivotFilters.Add Type:=xlTopCount, DataFiled:=... ' recorded
	•	Activesheet.Shapes.Range(Array("Button 1")).Select
	•	ActiveSheet.Unprotect
	•	ActiveWindow.Activate
	•	Activewindow.Caption
	•	ActiveWindow.FreezePanes = True/False
	•	ActiveWindow.SelectedSheets.Delete - recorded to delete multiple sheets (displayalerts=false) to turn off warning
	•	ActiveWorkbook after opening an excel file
	•	ActiveWorkbook.Close False
	•	ActiveWorkbook.FullName
	•	Activeworkbook.name
	•	ActiveWorkbook.Names("dataset").RefersToR1C1 = "=cpt_input_data!R1C1:R40C13"
	•	ActiveWorkbook.RefreshAll
	•	ActiveWorkbook.Save
	•	ActiveWorkbook.SaveAs sFile
	•	ActiveWorkbook.SaveCopyAs sFile
	•	ActiveWorkbook.Worksheets("....").Autofilter.sort.sortfileds.clear ' clears a filters sorting ' recorded
	•	ActiveWorkbook.worksheets("sfile1").sort.sortfields.Add Key:=Range("N2"), SortOn:=xlSortOnValues, order:=xlAscending, DataOption=xlSortTextAsNumbers
	•	Add Columns to a report
	•	Add Columns to a Report Manually Maintained
	•	Add Hyperlinks to a Report
	•	addAITs
	•	AddBorders
	•	Added after time separate process to add more slides with complex rules
	•	AddFieldToDB (sfield, sTable, stype)
	•	AddFinalSlash - udf - files
	•	AddLinks - convert Jira into links
	•	AddRatingColumns
	•	AddSemicolon - db - udf - adds a semicolon to the end of a string if one doesn't exist or to beginning as it's a comment
	•	AdjustLabelPosition - udf - charts
	•	Adjustment Logic
	•	After opening an external spreadsheet verify that it's okay - coding
	•	AHK to increase productivity (separate book)
	•	AI - Checkers
	•	AI BlackJack
	•	ALED - A Little Each Day
	•	Algebra vs Programming Assignment Statement
	•	align_ok_key(lKeyCol1 as Long, range1, lkeyCol2 as long, range2) - udf - 🔝 Aligns data from 2 sources
	•	Analogy between programming language and real language
	•	API - Public Declare Function ShellExecute Lib "Shell32.dll" Alias "ShellExecuteA(ByVal hWnd As Long, ...
	•	API - Public Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
	•	Applciatoin.UserName
	•	AppLen - udf -wrapper - handles null value
	•	Application.AskToUpdateLinks = false
	•	Application.Autocorrect ' record
	•	Application.Calculate
	•	Application.CalculateFull ' recorded
	•	Application.Calculation = xlCalculationAutomatic ' optimization
	•	Application.Calculation = xlCalculationManual ' recorded
	•	Application.Caption
	•	Application.CutCopyMode = False - gets rid of crawling ants
	•	Application.DisplayAlerts = False ' get rid of unneeded dialog box
	•	Application.EnableEvents = False
	•	Application.EnableEvents = True/False
	•	Application.ErrorCheckingOptions.BackgroundChecking = False ' recorded optimize
	•	Application.Evaluate("=vlookup(""" & ..... & """,'" & from ....
	•	application.evaluate(sLookup) - runs a vlookup or match or other excel statemnt
	•	Application.Height
	•	Application.IgnoreRemoteRequests
	•	Application.Left
	•	Application.OnKey
	•	Application.Ontime Dateadd("n",30, Now(),"Sub_to_run_name" ' i
	•	Application.Run - can be used to run a passed function on parameters - code in pptools - Callback_testing
	•	Application.ScreenUpdating = True/False ' used for optimization
	•	application.statusbar =
	•	Application.width
	•	Application.WindowState = xlMaximized - recorded
	•	Application.WindowState = xlNormal - recorded
	•	Applicaton.WindowState = xlMaxmized ' recorded
	•	Appplication.Top
	•	AR - sc for Activecell.row
	•	Archive
	•	AreTheyTheSame - internet function udf to check if 2 files are the same
	•	Array -start with "a", array function
	•	Array(string, string, ....) - Converts a list of strings to an array
	•	Arrays vs. Collections
	•	As Boolean (duplicate)
	•	As Boolean ... True/False
	•	As Byte
	•	As DAO.Recordset
	•	As Excel.Range
	•	as Integer
	•	As Long
	•	As Object
	•	as Outlook.Application
	•	as Range
	•	as Single
	•	as String
	•	as Variant
	•	As Word.Application
	•	As Word.Document
	•	As Worksheet
	•	Asc( ) - VBA string func converts s to a number
	•	Ask user a question and proceed from their answer
	•	Ask user via DispYN - (ex. run full version or "quick" one)
	•	ASP
	•	Assign a value to a cell - Range("xxx") = "a value"
	•	Assignment stmt
	•	Attach a file to an email
	•	auto_open - udf
	•	autocomplete
	•	AutoFilterMode
	•	Autofit
	•	AutoHotKeys
	•	Automate Manual Tasks