Simple Macro?
Absolutely not!
The ActiveCell ALWAYS is assigned as long as a workbook is Active.
When multiple cells are selected, the ActiveCell is whichever cell has
the focus. It's still populated even if a Shape is selected.
In article ,
Vergel Adriano wrote:
The reason it's jumping to End Sub is because when you selected B2:B30, there
is not just one cell selected. The ActiveCell object was empty.
|