Set a variable to a value in a cell(X=Row,Y=Column):

variable_name = Worksheets(“sheet_name”).Cells(X, Y).Value

Clear the clipboard:

Application.CutCopyMode = False

Select all cells that currently have data from a starting point “F1”:

Range(“F1”).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select

Have a message box pop up with an “OK” button

MsgBox “Starting Update ALL – Wait for Done Message!”

Switch to a different sheet:

Sheets(“Example_Sheet”).Select

Run a Macro from within a macro:

Application.Run “‘file_name.xlsm’!name_of_macro”

or

Application.Run “name_of_macro”