Thread: How to: copy value from active sheet to all other sheets with VBA (in desired cell)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Glynn Greg Glynn is offline
external usenet poster
  
Posts: 137
Default How to: copy value from active sheet to all other sheets with VBA(in desired cell)
Sub Button1_Click()
'
' Button1_Click Macro
'
Dim ws As Worksheet

MyVal = Range("C3")

For Each ws In Worksheets

ws.Range("C3").Value = MyVal
Next ws

End Sub
Reply With QuoteReply With Quote