Copying data to all subsequent sheets in Excel using VBA

[snowman01]

I need a change on one Excel sheet to be duplicated on all subsequent sheets within the same Excel spreadsheet file.

For example if I change cell A1 on sheet3 to read "Hello" then sheet4 onwards will also display the word "Hello" in cell A1.

The change of subsequent sheets will be activated on the click of a button.

I have the following code within a loop

sheetName.Cells(27, 5) = valueToSet

Even though the excel VBA code assigns the next sequencial sheet name to SheetName, when the code runs it generates the following error:-


Run - time error '424'

Object Required


Has anybody any solutions to this problem?


Thanks in advance

 

[SkipVought]

Hi,

Why would you have the same data on all sheets?

Oh well. This is really a VBA question, that belongs in Forum707. Please repost your question there.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}