Multiple Goal Seek
Hello,
I am not sure what is wrong with my code. I want to change the cells in worksheet bb to 0 by changing the cells in ci. Example: changin h12 in ci to get 0 in h158 in bb sub gg() Dim c As Object For Each c In Worksheets("bb").Range("d158:ay158") c.GoalSeek Goal:=0, ChangingCell:=Worksheets("ci").Range("d12:ay12") Next End Sub thanks, |
All times are GMT +1. The time now is 05:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com