Excel Macro Workshop File
Worksheets
Instructions
PrettyBlank
lastRow1
lawRow2
RemoveFormula
Copyright, usage, licenses
This Excel file is shared under CC BY-NC 4.0
Although you are not required to do so, if you decide to use this
material to present, or you adapt it and redistribute it, I would
appreciate an email at [email protected] so that I can
mention it in my annual report.
Who put this Excel file together?
Julie Marcoux, Data Librarian and GIS & Data Coordinator,
Dalhousie University
Last updated
April 2024
Description
Instructions on macro-related tasks to attempt on the other spreadsheets in this file.
A pretty blank worksheet. Follow the instructions in the instructions spreadsheet.
A spreadsheet used with the doesitwork macro. Follow the instructions in the instructions
spreadsheet.
A spreadsheet used with the doesitwork macro. Follow the instructions in the instructions
spreadsheet.
A spreadsheet used with the RemoveFormula macro. Follow the instructions in the
instructions spreadsheet.
CC BY-NC 4.0 link
[email protected]
Profile link (has contact info)
https://creativecommons.org/licenses/
by-nc/4.0/
https://dal.ca.libguides.com/prf.php?
account_id=53640
Let's have some fun with macros!
Start
Load in the contents of Excel Macros - Workshop File - Example Macros.txt
RemoveFormula
Select the "RemoveFormula" worksheet. Click on A1 - notice the formula?
While A1 is selected, run the "RemoveFormula" macro. Look at A1. Cool! The formula is gone!
DataGuideLink
Select the "PrettyBlank" worksheet.
Run the "DataGuideLink" macro. Cool!
Step into the code of "DataGuideLink". Change the link, the text of the link, or both.
Try it out!
GetNumber
Click on the "PrettyBlank" worksheet.
Run the "GetNumber" macro. Super cool!
Change the "GetNumber" macro so that it accepts numbers between 1 and 10.
CycleThrough
Run the "CycleThrough" macro in the "PrettyBlank" worksheet.
Whoaa, what happened there? Explore the code of the macro to find out.
bitsNpieces
Select the "lastRow1" worksheet.
Run the "Doesitwork" macro. Does that work? Yes? Good!
Select the "lastRow2" worksheet.
Run the "Doesitwork" macro. That doesn't work? Things are not bolded all the way down?
Modify the "Doesitwork" macro so that it will work no matter how many rows of data there are too bold.
Take a look at "bitsNpieces" for inspiration, or try Googling a solution.
[email protected] – Dalhousie University Libraries – CC BY-NC 4.0
To
boldly go
where
no man
has gone
before
Space, the final frontier
These are the voyagers of the Starship Enterprise
Its five years mission
To explore strange new worlds
To seek out new life
And new civilizations
To
boldly go
where
no man
has gone
before
This is the final countdown
This
is
the
final
countdown
