View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas[_13_] Thomas[_13_] is offline
external usenet poster
 
Posts: 4
Default Find active cell

New to Excel VBA. The following does not return the current active cell
but returns error 91.

Sub Macro1()
'
' Macro1 Macro
'
Dim rangeCurrentCell As Range
'
rangeCurrentCell = ActiveCell

'more stuff

The defn. of ActiveCell is confusing me. All I want is the currently
selected in A1 type format.

Thanks.

Thomas