How can I set values for a cell in every sheet of a workbook?

**tripflex** · 03-05-2009, 06:16 PM

Okay, after some great help from someone on here to the solution of my previous question, i now have another one.

I have approximately 100 sheets in a workbook. I want to set the value of cell C5 to same exact thing for every sheet.

Is it possible to do this without manually going into each sheet and pasting the code?

Thanks!!

**VBA Noob** · 03-05-2009, 06:30 PM

Right click the sheet tabs > Select all sheets > Type in C5 then unselect the sheets either by selecting one or right click > Ungroup

VBA Noob

**dominicb** · 03-05-2009, 06:30 PM

Good evening tripflex

Originally Posted by tripflex

Is it possible to do this without manually going into each sheet and pasting the code?

Sure is! Select your first sheet. Now hold down Shift and click on your last sheet.

You have now entered Group Mode (see your status bar at the top), a potentially very destructive feature of Excel. Use with caution and always switch off when you're done.

Go to C5 and type your text.

To turn off, right click any sheet and select Ungroup Sheets.

HTH

DominicB