Hi Folks, I'm new to the forum.
I have several spreadsheets that I've used for years.
I often use the GoalSeek function, but have a new problem.
In a sheet I recently edited all of the goalseek macros return the
"wrong number of arguments or invalid property assignment" error.
The second RANGE is highlighted.
********************************************************
Sub ZeroAZ()
'
' ZeroAZ Macro
' Macro recorded 5/5/2007 by Mark Page
'
Application.ScreenUpdating = False
RANGE("L53").GoalSeek Goal:=0, ChangingCell:= RANGE("D7")
End Sub
*********************************************************
I get this error in this sheet for every use of GoalSeek, but not in any other sheet.
Help!
Bookmarks