Just picked up on this thread.The answer is very simple. Use GoalSeek with target cell = D38, value =0, cell to change = G34.And if you want to do this in VBA, just record your steps, and then youcan automate it.