Hello,
I want to make a macro that will grab the location of the selected cell and input this as A1 below
Then, a button on the spread sheet would run the macro.
It's fairly simple but it's my first time with macros. Can you help me please?
I want to make a macro that will grab the location of the selected cell and input this as A1 below
Code:
Range("B1").GoalSeek Goal:=10, ChangingCell:=Range("A1")
Then, a button on the spread sheet would run the macro.
It's fairly simple but it's my first time with macros. Can you help me please?