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?
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?