VBA Window Split

I just found out you can split the VBA code window. See images below.

Use the small icon above the right side scroll bar.

This can be useful if you have a long block of code and need to look at separate parts together.

Thanks to Bob Umlas the Excel MVP for sharing.


You can double click the split bar to remove it.

Related Posts

One Minute to Excel #30 – Extract Data Based on Sheet Name

Shortcut to speed up name creation

Here’s a technique I use a lot to speed up report development.

Sheet names have to be unique, so they can’t be duplicated. This makes them great for department names or states.

This short video combines a few techniques to extract from a data set based on the sheet name.

All in less than a minute.

The Carbon Almanac (Penguin, 2022)

Facts. Connection. Action.

With a forward by Seth Godin this is an unusual book.

Filled with FACTS about climate change, it was created by people from around the world.

The authors had different backgrounds and specialisations.

The book covers all the aspects of climate change.

There are many different problems we are facing caused by many different industries.

This book explains the problems and covers what we can do to avert a climate disaster.

It is not too late, but we don’t have much time – we need to act now!

Check out the website here.

Update 30/12/22

This book won a Data Literacy award – link below.

Announcing the Winners of the 2022 Data Literacy Awards!