$$Excel-Macros$$ edit all sheets in a workbook at the same time?

Hi. I have been using Excel for years but never really needed to get into VBA too much .. usually recording the macro was sufficientbut now I am learning VBA as I go. I want to know if there is a command which will allow me to all sheets in a workbook at the same time. I want to enter text i

$$Excel-Macros$$ Re: edit all sheets in a workbook at the same time?

Thanks .. I learn something new every day! On 7 Sep, 16:18, Norman May wrote: > You can select the first sheet tab, hold the shift key then select the last > sheet tab. > This will activate all sheets. > Enter the desird content of the any cell > > > > On Mon, Sep 7,