study the lemma 'with ... end with' in the VBA helpfiles or your VBA handbook.