VBA - Method not available?

[Ash1432]

I am really trying to learn VBA coding, and I am a super beginner. I'm watching a video where the person records a macro using the Goal seek functionaltiy. The VBA that was created is Range("B4".GoalSeek Goal:= 500, ChangingCell:=Range ("B3")

I can recreate the recording of the macro and get the same outcome. But since I want to learn VBA I was trying to create this macro without the recorder. When I do this and I type Range("B4. Goal seek is not listed or showing as being available to use. Can someone explain why that would be?

 

[rlv01]

There is no why. It's just one of those quirks. You have to first type "R.GoalSeek". Then it will show you the syntax

Sub GSVBAExample()
    Dim R As Range, CC As Range
    
    Set CC = ActiveSheet.Range("A1") 'changing cell
    Set R = ActiveSheet.Range("B1")  'result cell
    
    CC.Value = 0
    R.Formula = "=" & CC.Address(False, False) & "*2+10" 'create a formula for the example
    
    R.GoalSeek Goal:=100, ChangingCell:=CC
    
    MsgBox "CC Value for R = 100 is " & CC.Value
End Sub