newtoloop

Posts: n/a

Goal Seek on Multiple Cells

I don't know the loop statements very well. I want to do the following goal
seek on a number of cells in the same row. Can anyone help?

Sub
Dim X As String
X = Range("A1").Value
Range("A10").GoalSeek Goal:=X, ChangingCell:=Range("B1")
If Range("B1")<Range("A1") then Range("B1") = Range("A1").Value
End if
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to determine which rows contain slected cells in a multiple c.	Paul	Excel Worksheet Functions	2	April 5th 05 05:07 PM
goal seek vs solver	neoschenker	Excel Worksheet Functions	3	February 3rd 05 03:56 PM
how do i add the same text after current text in multiple cells	Sue	Excel Discussion (Misc queries)	3	January 13th 05 09:28 PM
Goal Seek - Why make the PV negative?	Mytpoet67	Excel Discussion (Misc queries)	1	January 13th 05 02:51 AM
background formatting across multiple cells	Casper	Excel Discussion (Misc queries)	0	November 26th 04 11:18 AM

All times are GMT +1. The time now is 09:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us