| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with macro syntax
getting type mismatch error.
Sub goalsk() Dim R As Long 'Row For R = 4 To 16 Range("B" & R).GoalSeek goal:=0.42, ChangingCell:=Range("C" And R) Next R End Sub |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with macro syntax
replace:
Range("B" & R).GoalSeek goal:=0.42, ChangingCell:=Range("C" And R) with: Range("B" & R).GoalSeek goal:=0.42, ChangingCell:=Range("C" & R) -- Gary''s Student - gsnu200832 "Steve" wrote: getting type mismatch error. Sub goalsk() Dim R As Long 'Row For R = 4 To 16 Range("B" & R).GoalSeek goal:=0.42, ChangingCell:=Range("C" And R) Next R End Sub |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with macro syntax
thank you. i should have caught that.
"Gary''s Student" wrote: replace: Range("B" & R).GoalSeek goal:=0.42, ChangingCell:=Range("C" And R) with: Range("B" & R).GoalSeek goal:=0.42, ChangingCell:=Range("C" & R) -- Gary''s Student - gsnu200832 "Steve" wrote: getting type mismatch error. Sub goalsk() Dim R As Long 'Row For R = 4 To 16 Range("B" & R).GoalSeek goal:=0.42, ChangingCell:=Range("C" And R) Next R End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Correct syntax for IF, Then in a macro | Excel Worksheet Functions | |||
| Copy And Paste Macro Syntax Problem | Excel Worksheet Functions | |||
| macro syntax for selecting variable range | Excel Discussion (Misc queries) | |||
| question about syntax in a simple macro... | Excel Discussion (Misc queries) | |||
| VBA: syntax to review macro names in a file? | Excel Discussion (Misc queries) | |||
Hybrid Mode
