You could do it without a loop. As indicated by Hariharan, selecting all
sheets and then adding the code will do the trick. For a VBA, paste this to
the code module of the first sheet.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.HasFormula Then
Target.Select
ThisWorkbook.Sheets.Select
Application.EnableEvents = False
Selection.Formula = Target.Formula
Application.EnableEvents = True
ActiveSheet.Select
End If
End Sub
Regards,
Sam Mathai Chacko (GL)
On Wed, Oct 5, 2011 at 9:01 PM, <hariharan.thara...@wipro.com> wrote:
> Select all the sheets first and then write a formula wherever you need
> in Excel.
>
> The formula will be coming in all the sheets.
>
> Thanks,
> Hariharan Tharagan
>
> -----Original Message-----
> From: excel-macros@googlegroups.com
> [mailto:excel-macros@googlegroups.com] On Behalf Of renuka chari
> Sent: Tuesday, October 04, 2011 8:16 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Macro Reg:
>
> hi experts!
>
>
>
> i am having a excel workbook, it contains 10 sheets
> my query is "if i enter a one formula in first sheet in specific range
> in one column that formula should be add in specific range in other
> sheets at single time" is it possible
> if any macro or macro sheet cna you send as soon as possible
> Plzzzzzzzzz
>
>
>
>
> thanks in advance
>
> --
> ------------------------------------------------------------------------
> ----------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Sam Mathai Chacko
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
