Beginner
Exercise 1
In the first exercise, we will focus on variables and some calculations using arithmetic operators.
Expand | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||
|
Exercise 2
In this exercise it is recommended to use the Record macro-feature available in VBA, although you don't necessarily have to.
Expand | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||
Make a macro that deletes all but the first sheet. The macro should not take into consideration if any sheets are written on. Some pictures showing before and after running the desired macro are presented below.
|
BibTeX Display Table |
---|
Beginner
Exercise 1
In the first exercise, we will focus on variables and some calculations using arithmetic operators.
Expand | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||
|
Exercise 2
In this exercise it is recommended to use the Record macro-feature available in VBA, although you don't necessarily have to.
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Make a macro that deletes all but the first sheet. The macro should not take into consideration if any sheets are written on. Some pictures showing before and after running the desired macro are presented below.
|
BibTeX Display Table |
---|
Beginner
Exercise 1
In the first exercise, we will focus on variables and some calculations using arithmetic operators.
Expand | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||
|
Exercise 2
In this exercise it is recommended to use the Record macro-feature available in VBA, although you don't necessarily have to.
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Make a macro that deletes all but the first sheet. The macro should not take into consideration if any sheets are written on. Some pictures showing before and after running the desired macro are presented below.
|
BibTeX Display Table |
---|