Thomas,

Object variables are assigned with the Set command

Set rangeCurrentCell = ActiveCell

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Thomas" wrote in message
...
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