Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
549 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
This page lists the 11 exercises about Selecting cells in Excel VBA Macros on our website:
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Relatively easy |
Exercise: | Select one cell in a battleships grid relative to another. |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Relatively easy |
Exercise: | Write a simple macro to guide Red Riding Hood through a maze, using lots of OFFSET commands. |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Relatively easy |
Exercise: | Write a subroutine to enter your details into an application form for a dating agency. |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Relatively easy |
Exercise: | Write code to change the colour of cells and sink ships in a rudimentary version of Battleships. |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Relatively easy |
Exercise: | Write macros to select various ranges absolutely using a battleships game as template. |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Relatively easy |
Exercise: | Write one or more simple macros to fill in capital cities on different worksheets (shows selecting worksheets and selecting cells). |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Average difficulty |
Exercise: | Use the End and Offset properties in Excel VBA to copy the details of dating-agency applicants to the end of a list. |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Average difficulty |
Exercise: | Write a macro to select a column of celebrity marriage data, then amend it to select a rectangular block. |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Average difficulty |
Exercise: | Write a macro to select the last task in a block of tasks for Bob the Builder. |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Harder than average |
Exercise: | Create a macro to select almost down to the bottom of a block of Muppets data (using OFFSET and END). |
Software: | Excel VBA Macros |
Topic: | Selecting cells |
Level: | Harder than average |
Exercise: | Practise on a battleships grid using more difficult selection techniques, such as resizing a selection and using the UNION method. |
You can search our full list of VBA exercises here. Or why not learn to do them the right way on one of our VBA training courses? You can attend our online training classes wherever you are in the world!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.