View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DVAL DVAL is offline
external usenet poster
 
Posts: 10
Default How to: copy value from active sheet to all other sheets with VBA (in desired cell)

Does anybody can help me?
I tried with command button
with macro:

Sub Button1_Click()
'
' Button1_Click Macro
'
Dim ws As Worksheet

Range("C3").Select
Selection.Copy
For Each ws In Worksheets

Range("D10").Select
ActiveSheet.Paste

Next wSheet
End Sub