Programming A formula

[Joseph]

Hi Bernie,

Unfortunately there re other sheets in there. But they are numbere
like so: Sheet1, Sheet2, Sheet3 etc. The other 231 are name
differently. And unfortunately I got a syntax error from your code? An
ideas?

cheer

 

[Bernie Deitrick]

Joseph,

IF your sheets are arranged so that there aren't any Sheet1, etc. sheets
between the sheets you want to sum, then simply

MsgBox Evaluate("=Sum('First Sheet Name:Last Sheet Name'!B2)")

changing First Sheet Name to the actual sheet name of interest, etc.

The syntax error you received was probably due to the extra line break
inserted by our newsreaders.

HTH,
Bernie
MS Excel MVP