Thermometer charts are useful if you want to display actual values against target values: for example actual sales against sales target. Follow the tutorial or watch our YouTube tutorial at the bottom of this page. Please see our Excel Dashboard training course if you would like this training delivered at your place of work. Here’s an…
Read More
Referring to a Workbook Using ThisWorkbook
|
1 2 3 |
Dim wb As Workbook Set wb = ThisWorkbook wb.Close SaveChanges:=True |
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!
|
1 |
Workbooks.Open Filename:="C:\Users\xxxx\Desktop\Finance.xlsx", ReadOnly:=True |
|
1 |
Workbooks("Finance.xlsx").Close SaveChanges:=True |
|
1 |
ActiveWorkbook.Close savechanges:=True,Filename:="C:\Users\xxxx\Desktop\Test.xlsx" |
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!
|
1 |
ActiveWorkbook.Save |
|
1 |
ActiveWorkbook.SaveAs Filename:="C:\Users\xxxx\Desktop\COPY_Test.xlsx" |
|
1 |
Kill "C:\Users\xxxx\Desktop\COPY_Test.xlsm" |
|
1 |
ActiveWorkbook.Protect Password:="BadPassword" |
Select a Specific Worksheet
|
1 |
Worksheets("Expenditure 2016").Select |
Refer to the Active Worksheet Using ActiveSheet
|
1 |
ActiveSheet.Range("A10").Interior.ColorIndex = 7 |
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!
|
1 |
Worksheets("Sheet1").Activate |
|
1 |
Worksheets.Add before:=Worksheets("Sheet4"), Count:=5 |
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!
|
1 |
ActiveSheet.Name = "New Name" |
|
1 |
Worksheets("Expenditure 2016 Draft").Name = "Expenditure 2016 Final" |
|
1 |
Worksheets("Sheet1").Tab.ColorIndex = 7 |
|
1 2 3 4 5 |
‘Disable dialog boxes Application.DisplayAlerts = False Worksheets("Sheet10").Delete ‘Enable dialog boxes Application.DisplayAlerts = True |
|
1 |
Worksheets("Sheet1").Copy before:=Worksheets("Sheet2") |
