The Best Web Host!!

Clear the contents of the selected cells in a macro

Clear the contents of the selected cells:

Selection.ClearContents

Open a workbook with a filename\location that is configured from another cell value

Open a workbook with a filename\location that is configured from another cell value:

ChDir “C:\Users\user_name\folder_one\folder_two”
Workbooks.Open Filename:= _”C:\Users\user_name\folder_name\Part_of_file_name1″ & variable & “.xls”

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

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 in a Macro

Clear the clipboard:

Application.CutCopyMode = False

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

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

Turn Off/On Auto Cal in a Macro

Turn Off Auto Cal:

Application.Calculation = xlCalculationManual

Turn On Auto Cal:

Application.Calculation = xlCalculationAutomatic

autocal

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

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

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

Switch to a different sheet

Switch to a different sheet:

Sheets(“Example_Sheet”).Select

Run a Macro from within a macro

Run a Macro from within a macro:

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

or

Application.Run “name_of_macro”

“The Scarecrow” – by Chipotle Mexican Grill

Just ran across this video… makes you think! Chipotle did a very good job.. Bowl Please!!  They have other interesting video on their You Tube Channel!

Watch “The Scarecrow,” the companion film for Chipotle’s new app-based game. Then download the free app at www.scarecrowgame.com and join the quest for wholesome, sustainable food.