“Compile error: Object Required” in Goalseek function

Asked Feb 27 '20 at 12:19

Active Apr 18 '20 at 20:00

Viewed 209 times

I am trying to automate the Goalseek function.

Sub Goalseek()
Dim rw As Integer
Dim cl As Integer

Set rw = ActiveCell.Row
cl = ActiveCell.Column
To_value = Cells(rw, cl - 25).Value

Cells(rw, cl + 6).Goalseek Goal:=To_value, ChangingCell:=Cells(rw, cl)

End Sub

And the

Compile error: Object Required

shows up.

edited Apr 18 '20 at 20:00

zonksoft

2,400
1
24
36

asked Feb 27 '20 at 12:19

microambitious

3

Remove the `Set` on the `rw =` line. – Brian M Stafford Feb 27 '20 at 12:25
2

As the error says, you need an object to use the `Set` keyword. `Integer` is not an object, it's a value type. – Kostas K. Feb 27 '20 at 12:25
1

https://stackoverflow.com/questions/349613/what-does-the-keyword-set-actually-do-in-vba – Siddharth Rout Feb 27 '20 at 13:18
1

Side note: you probably want to `Dim` the variables as `Long`. Excel can handle more rows than `Integer` can count – cybernetic.nomad Feb 27 '20 at 15:30

“Compile error: Object Required” in Goalseek function

0 Answers0