vba application.onkey

  1. G

    Using VBA & OnKey to delete rows with blank cells in a certain column

    Disclaimer: I'm a complete VBA newbie. I can get Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete to work in the "immediate" mode (with Cntrl-G in the macro editor) as per this post. However, I'd like to map this behavior to a key combo. I can't get this to work: Application.OnKey...

Some videos you may like

This Week's Hot Topics