Range Name problem

[cmz21]

Hello,
I am having a problem creating a named range using excel vba. I am using the code below, but instead of inserting the named range for cell B899, it is putting it at B1795. Anyone have any idea how this could be happening?

With xlBook
.Names.Add Name:="Count", RefersTo:="=B899", Visible:=True
End With

 

[SkipVought]

Hi,

Need the SHEET reference also...
[tt]
With xlBook
.Names.Add Name:="Count", RefersTo:="=Sheet1!B899"
End With
[/tt]


Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}

 

[cmz21]

Thanks