Goal seek

**tom1984** · 08-20-2009, 04:36 PM

Hello,

I'm new to VBA so this may be a trivial question.

I'm trying to run goalseek down a single column by changing the cell from another column in a different sheet.

My code is as follows:

Please Login or Register  to view this content.

The code works but I get a run time error? Why is this and how can I fix it?

Any help would be much appreciated.

**shg** · 08-20-2009, 04:38 PM

Welcome to the forum, Tom.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

**shg** · 08-20-2009, 06:19 PM

Thanks.

It works fine for me, though as the code is written, you have to have the GoalSeek sheet selected for it to work.

Post a workbook.

**tom1984** · 08-21-2009, 02:35 PM

hmmm strange.

I can't post the workbook, its got lots proprietary information in it.

Well thanks for looking at it anyway. Its very much appreciated.