This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Excel VBA Macros exercises on SELECTING CELLS

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

Software:	Excel VBA Macros
Topic:	Selecting cells
Level:	Relatively easy
Exercise:	Write macros to select various ranges absolutely using a battleships game as template.

Show this exercise

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).

Show this exercise

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.

Show this exercise

Software:	Excel VBA Macros
Topic:	Selecting cells
Level:	Average difficulty
Exercise:	Write a macro to select a column of celebrity marraige data, then amend it to select a rectangular block.

Show this exercise

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.

Show this exercise

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).

Show this exercise

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.

Show this exercise

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!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

EXERCISE TOPIC

VBA EXERCISES