Write a value on all worksheets in the workbook

[KhallP]

Good afternoon friends, is there any way to write a value in a specific cell on each sheet of the excel workbook using "Foreach" or in some other way?

Example: Write the number 3 in cell A3 of each sheet of the current workbook

 

[Fluff]

How about

Sub KhallP()
   With ActiveWorkbook.Worksheets
      Range("A3").Value = 3
      .FillAcrossSheets Range("A3"), xlFillWithAll
   End With
End Sub

 

[KhallP]

How about

Sub KhallP()
   With ActiveWorkbook.Worksheets
      Range("A3").Value = 3
      .FillAcrossSheets Range("A3"), xlFillWithAll
   End With
End Sub

Sorry, I will specify better, I have a spreadsheet with 3 sheets ("Sheet1", "Sheet2", "Sheet3") on each sheet the intervals from A10 to A25 have different data and in cell C20 of each sheet the value will be result of the sum of the intervals A10 to A25 (all with different results on each sheet, that is, the result of cell C20 will always be different on each sheet)

 

[Fluff]

Then why on earth did you say

Write the number 3 in cell A3 of each sheet of the current workbook

which is absolutely nothing like what you appear to want?

 

[KhallP]

Then why on earth did you say

which is absolutely nothing like what you appear to want?

Sry can u help me or no?

 

[Fluff]

Not unless you explain clearly & accurately EXACTLY what you want.

 

[KhallP]

Not unless you explain clearly & accurately EXACTLY what you want.

Already explained

 

[Fluff]

Not as far as I am concerned. Please remember that I cannot see your data, not can I read your mind. What EXACTLY do you mean by

the intervals from A10 to A25 have different data

and

C20 of each sheet the value will be result of the sum of the intervals A10 to A25