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!!

Right click on one of the worksheet tabs.
Click on Select all sheets
type the value in C5
right click on any of the grouped sheet tabs
Click on Ungroup sheets

This can be a very useful feature (like for what you want), but if you forget to
ungroup the sheets, it can be disastrous!

tripflex wrote:

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!!

--

Dave Peterson

Yes and it is easy
Click on the tab of the first worksheet to be processed
Hold SHIFT and click on the last worksheet
Your worksheets are now said to be 'grouped' - note how the tabs of all
grouped worksheets have the same colouring/shading
Type the value into C5
Click on the tab of any worksheet to ungroup
Check a few worksheets to confirm all went well.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"tripflex" wrote in message
...
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!!

you could right-click at the bottom, on the name of "Sheet1" and select
"select all sheets"
--
_____________________
Join the club! Havana Club.


"tripflex" wrote:

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!!

Awesome, thank you so much! I love this forum it has saved me hours or work!

"Dave Peterson" wrote:

Right click on one of the worksheet tabs.
Click on Select all sheets
type the value in C5
right click on any of the grouped sheet tabs
Click on Ungroup sheets

This can be a very useful feature (like for what you want), but if you forget to
ungroup the sheets, it can be disastrous!

tripflex wrote:

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!!

--

Dave Peterson