Thread: Simple Macro?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.