expertatexcel.com

Standard VBA/Excel (128 of 1182)

	•	s,Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ::-""??_);_(@_)" 'recorded (g)
	•	SaveAllAsPDFFile - Internet - https://howto-outlook.com/howto/saveaspdf.htm - Robert Sparnaaij
	•	SaveCopyAs
	•	SaveStringToFile - udf 🔝
	•	SaveStringtoFile string, "c:\xyz.txt" - saves a string to a file
	•	sCol = cl((c))
	•	Scope of variables
	•	Screen Flashing Problem
	•	Scripting.FileSystemObject"
	•	Searching for Excel/VBA Answers
	•	SECDataAvailable - udf - db - checks for a condition (cob date from db > month-end data) and send email, generates a file
	•	Second(now())
	•	Select a cell - Range(...).select
	•	Select a column - Columns(i).select
	•	Select Case - vba stmt
	•	Select Case
	•	Selection Pane
	•	Selection. (formula, copy)
	•	Selection.Address - vb property - returns the $A$1 formatted address of the selected cell(s)
	•	Selection.Autofill destination:=Range("H2:I" & r)
	•	Selection.autofilter = turns off filter
	•	Selection.Characters.Text = "Add TOC" ' after selecting a button, you can change the text
	•	Selection.Copy - copies the active selection to the clipboard
	•	Selection.copy
	•	Selection.CurrentRegion.Select
	•	Selection.cut - Clipboard
	•	Selection.Delete Shift:=xlUp ' recorded
	•	Selection.End(xlUp).select ' recorded
	•	Selection.EntireColumn.Hidden = True ' recorded
	•	Selection.Font.Underline = xlUnderlinestyleSingle
	•	Selection.Insert Shift:=xlToRight - recorded
	•	Selection.Left or Top, Height, width, name after chartobject is activated
	•	Selection.Merge
	•	Selection.Numberformat = "#,##0.0,,,"
	•	Selection.NumberFormat = "m/d/yyyy"
	•	Selection.NumberFormat = "mmm-yy" (dup)
	•	Selection.NumberFormat = "mmm-yy"
	•	Selection.NumberFormat = (dup)
	•	Selection.OnAction = "TOC1.AddTocSheet" ' Select the shape first via ActiveSheet.Shapes.Range(Array("Button 1")).Select
	•	Selection.PasteSpecial ... ' recorded
	•	selection.PasteSpecial Paste:=xlPasteColumnWidths, ..' recorded
	•	Selection.Pastespecial Paste:=xlPasteValues... 'recorded
	•	Selection.Replace what:="#N/A", Replacement:="0", LookAt... 'Recorded
	•	Selection.Rows.Count
	•	Selection.WrapText = False ' recorded
	•	SelectPartialSheetName - I wouldn't know the whole name of a sheet but knew part of it's name
	•	Seletction.Style = "Percent" ' recorded
	•	SendChecklist_email() - udf - sends a formatted email as a checklist to proper person to dbl check report
	•	SendEmailFromList - Goes thru a spreadsheet and Sends emails
	•	Sendkeys "^A",True
	•	sendmail_cdo udf
	•	sendmail_cdo
	•	SendMailto( ) udf
	•	SeqIO.bas
	•	set fso = CreateObject("scripting.filesystemobject")
	•	Set gADO = GetConnection(GetDatasource())
	•	Set gADO = GetConnection(GetDatasource())
	•	Set IE = New InternetExplorer
	•	set iMsg = CreateObject("CDO.Message")
	•	set objSelection = objOL.ActiveExplorer.Selection (not sure what this is)
	•	Set PPApp = GetObject(, "Powerpoint.Application")
	•	Set PPT = CreateObject("Powerpoint.Application")
	•	Set ppttemplate = PPT.Presentations.Open(sFile, ReadOnly = msoTrue
	•	Set rs = nothing
	•	set wb = ActiveWorkbook
	•	set wrdApp = CreateObject("Word.Application")
	•	Set x = CreateObject("MSXML2.XMLHTTP")
	•	SetAttr
	•	SetAttr sFilename, vbReadOnly
	•	SetAutoFitMergedCell udf Report Engine
	•	Setting a Hyperlink on a cell in a ppt table
	•	Setting Sheet
	•	Shapes, Smartart, Screenshots
	•	SharePoint
	•	sheet names
	•	Sheet names have size and character limitations
	•	SheetExists - udf
	•	Sheets aka WorkSheets
	•	Sheets Collection
	•	sheets vs. worksheets collection?
	•	Sheets("name").select - selects a sheet
	•	Sheets(2).visible = True
	•	Sheets(Array("sheet1","sheet2").copy
	•	Sheets.count
	•	ShellAndWait API
	•	Show directory via File Explorer - RunProgram "C:\directory_name"
	•	Show Formula Mode - `Ctrl` `
	•	ShowSheet - udf - wraps the code to prevent errors
	•	Sleep - API
	•	Slicer
	•	Small to big - coding technique
	•	Small to big, one piece at a time
	•	Space$(512)
	•	Sparklines
	•	Special Characters
	•	Split(string,"value") - converts string into an array
	•	SpreadSheetRoutines.bas
	•	SQL - Check return from query
	•	SQL Create
	•	SQL delete
	•	SQL drop
	•	SQL insert rows from data
	•	SQL insert
	•	SQL truncate
	•	SQL update
	•	SQL
	•	SQLStuff.bas
	•	SSRS - SQL Server Reporting Services
	•	Stack - Used in Call Stack
	•	Standard error handling
	•	Static variable
	•	Status while running a process so user doesn't think it hung up🔝
	•	Status
	•	StatusBar
	•	Stop
	•	Stop: resume next: Resume - Debugging and why?
	•	Stopping Running Code - `Ctrl` `Break`
	•	Strings
	•	stringtobytearray - internet
	•	Student Knowledge
	•	Sub - End Sub
	•	subroutine parameters
	•	Subscript out of range
	•	Subtotal function - excel
	•	Summary Statistics
	•	Syntax Checker
	•	Syntax errors
	•	Syntax