perform the same calculation in several spreadsheets

[sam.fares]

Hello;



i have several sheets in a work book. the sheets names that i am
intersted in using are 20, 25,30,40,45, 55..... . there are other
sheets with names like 20S, 20R..... the ones that i want to apply
the calculations in are the ones that have numbers only. i would like
to be able to perform certain calculations in sheet 20, then perform
the same calculation in sheet 25 and so on. how could i write the code
for it? Thanks very much!

 

[dan dungan]

If the sheets are formatted identically, you could select the sheets
and enter the formula. This enters the formula in all sheets selected.

If that's no good, please describe your need with more detail.

Dan

 

[sam.fares]

If the sheets are formatted identically, you could select the sheets
and enter the formula. This enters the formula in all sheets selected.

If that's no good, please describe your need with more detail.

Dan

hello Dan,

i wrote a code that will perform some calculations . i have several
sheets in this book, and the names could be 20, 20s , 20R, 30,30s,
30R..... and so on. i want to execute the code i wrote inside all
sheets that have have a name like 20,30,40,45,...... . i dont want to
execute this code in sheets that has a name that include letters like
20s, or 20R, or 40s.....

 

[Sam Wilson]

sub EveryCertainSheet()

dim ws as worksheet
for each ws in worksheets
if isnumeric(ws.name) then call YourMacro
next ws

end sub