User-defined function creating circular reference
-----Original Message-----
As far as I can see nothing in your macro can cause this
error,
suggesting that the circular reference is already there.
Look at the status bar where 'Circular' will appear. Tab
through your
worksheets in turn until something like 'Circular A1'
appears.
Regards
BrianB
================================================= =
"Lesa Richmond"
wrote in message news:<042f01c34bd3$9f4ecc70
...
In Excel XP, I have cells E3:E62 that contain either
values or errors. (The errors are =NA() for charting
purposes.) I need to find the last value in the
column
and place that value in cell E64.
The function I wrote (in its own module) is:
Function LastAADF()
ActiveSheet.Range("E62").Activate
Do
If IsError(ActiveCell) = True Then
ActiveCell.Offset(-1, 0).Activate
Else
LastAADF = ActiveCell.Value
Exit Do
End If
Loop
End Function
When I put the formula =LastAADF() in cell E64, Excel
says I've created a circular reference. Can someone
tell
me what I've done wrong?
Lesa
.
Thanks for your response, Brian. Looks like we both
learned something today: see Dave Peterson's response -
he explained the problem.
|