Thread: Check Selection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych[_4_] Tim Zych[_4_] is offline
external usenet poster
 
Posts: 58
Default Check Selection

If Typename(ActiveCell) = "Range" Then
ActiveCell.Select
End If

"Chris Gorham" wrote in message
...
Hi,

I want to make sure that when I write code such as
activecell.select that the macro doesn't bug out because
an object such as a chart happens to be currently selected
on the s/sheet and not a cell range.

thks...Chris