Hi, Solution given by Sam is better than using loop.
Regards, Swapnil. On Wed, Oct 5, 2011 at 11:24 PM, Sam Mathai Chacko <samde...@gmail.com>wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
