Hi all.

I'm trying to code a goal seek, however the RANGE i want to select is typed in to cell m6.. eg.. depending on the formulated outcome i have in my workbook, the cell i am goal seeking is shown in cell m6.

If I100 is to be seeked, then I100 is shown in M6.

How do i reflect this in coding? currently i show:

Worksheets("Details").Range(m6).GoalSeek Goal:=0, ChangingCell:=Worksheets("Details").Range("l9")
Any ideas?