View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Jason is offline
external usenet poster
 
Posts: 367
Default GoalSeek 1004 Error

I am trying to use the GoalSeek function in my VBA, but am unable to get it
to work, I have been getting 1004 error

Here is the line that seems to cause the 1004 error

Worksheets("Data Sheet").Cells(1, 203).GoalSeek Goal:=Worksheets("Data
Sheet").Cells(1, 201).Value, _
Changingcell:=Worksheets("Data Sheet").Cells(1, 202)

Please let me know if you need more info.

Thank you,