Dears,
Good Day.
I am new user in VBA. And, I have run Goal Seek function. I have some rows that I want to run VBA Macro. But, when I select active cells to record macro is working fine. The issued with the macro is only working for first row. Not work for active cells "rows"
Sub Goals_seek()
'
' Goals_seek Macro
' Adjusment trade price
'
' Keyboard Shortcut: Ctrl+Shift+G
'
ActiveCell.GoalSeek Goal:=0, ChangingCell:=ActiveCell.Offset(0, -4).Range( _
"A1")
End Sub
Appreciate to support me.
Thanks
Good Day.
I am new user in VBA. And, I have run Goal Seek function. I have some rows that I want to run VBA Macro. But, when I select active cells to record macro is working fine. The issued with the macro is only working for first row. Not work for active cells "rows"
Sub Goals_seek()
'
' Goals_seek Macro
' Adjusment trade price
'
' Keyboard Shortcut: Ctrl+Shift+G
'
ActiveCell.GoalSeek Goal:=0, ChangingCell:=ActiveCell.Offset(0, -4).Range( _
"A1")
End Sub
Appreciate to support me.
Thanks