Stopping the Clipboard from being cleared in Excel VBA

How to check if the clipboard is empty

It is common knowledge (or it should be) that running a macro clears the undo list. In general you can’t undo a macro. However some macros also clear the clipboard which can stop you copying and pasting. I have found a workaround for the clipboard problem.

Inserting a Blank Row Between Entries

Manual technique

Over the years I have had many requests to help people insert blank rows between entries is a list. Apparently it is for an input routine that requires blanks. My normal solution is a macro because it automates the process, but there is a manual technique that is quick and easy.

My free Excel webinars are back

All webinars are not the same

I recently ran my first public webinar in nearly a year – Materials Link and streaming Video below.

I run free and paid Excel training webinars. Watch a recording or come along to a free session and see if you like them.

My aim is to make my live training webinars as enjoyable, useful and practical as possible, which means

  • no PowerPoint slides EVER
  • zero marketing or up selling – just Excel training
  • no recorded content – its all live and interactive – comments and questions can be sent via a chat box
  • detailed instruction manuals – yes, even the free sessions have a detailed pdf manual
  • the free session recordings are always available – no time limits on watching
  • paid recordings can also be downloaded
  • annual attendance listing for CPD purposes when you attend a live session (sent out late January each year)
  • you must record your own CPD when you watch a recording (like the one below)

Download Materials

Excel Formula to Extract the Domain

Using the SUBSTITUTE function

I recently read a blog post about using Excel for SEO (Search Engine Optimisation). It mentioned a function to extract a domain from a URL. The function was from Google docs, not Excel. So I wrote an Excel formula to extract the domain from their list of URLs.