How to tell a excel cell is empty?

Hi guys, I am very exciting to use keyboard maestro to accomplish some repetitive works.
Now I am trying to copy the text in a row in excel to pro tools (an audio software) to name the marker, Now I have achieved that by copy and paste by switch two apps.
But i want to let the Marco stop at the moment where the cell in the row is empty, there is no text in it.
I am thinking using set clipboard to variable, or set variable to clipboard. I am not good at programming , i am quite confused. :slight_smile: :exploding_head:

1 Like

Before you copy the row, do a KM Copy of just the cell.

To test, select a cell in Excel and run this macro:

Below is just an example written in response to your request. You will need to use as an example and/or change to meet your workflow automation needs.

Please let us know if it meets your needs.


MACRO:   Determine if Excel Cell is Empty (no text)

-~~~ VER: 1.0    2020-03-18 ~~~
Requires: KM 8.2.4+   macOS 10.11 (El Capitan)+
(Macro was written & tested using KM 9.0+ on macOS 10.14.5 (Mojave))

DOWNLOAD Macro File:

Determine if Excel Cell is Empty (no text).kmmacros
Note: This Macro was uploaded in a DISABLED state. You must enable before it can be triggered.


Thank you so much! It's very clear guide. Hope you have a nice day!!!

It might not help you but I do as much processing outside of Excel as I can: I process Comma-Separated Variable (CSV) files before importing into Excel.

It works really well. Thanks a lot!