Consecutive numbering
in [Functions]
|
From: Esradekan on 31 Mar 2010 20:28 Hope someone can help. How can I get one cell (B35) on each of 100 worksheets to number consecutively? TIA Esra >(*-*)<
From: Subodh on 31 Mar 2010 21:36 You should use VBA code for this. As far as my knowledge goes Worksheets functions won't work. On Apr 1, 5:28 am, Esradekan <esrade...(a)gmail.com> wrote: > Hope someone can help. > > How can I get one cell (B35) on each of 100 worksheets to number > consecutively? > > TIA > Esra > > > > >(*-*)<- Hide quoted text - > > - Show quoted text - U should use VBA code.
From: Esradekan on 31 Mar 2010 22:34 On Apr 1, 2:36 pm, Subodh <getsub...(a)gmail.com> wrote: > You should use VBA code for this. > As far as my knowledge goes Worksheets functions won't work. > > On Apr 1, 5:28 am, Esradekan <esrade...(a)gmail.com> wrote: > > > Hope someone can help. > > > How can I get one cell (B35) on each of 100 worksheets to number > > consecutively? > > > TIA > > Esra > > > >(*-*)<- Hide quoted text - > > > - Show quoted text - > > U should use VBA code. Thank you for the reply. Can you point me in the direction of how I can get VBA code for this? TIA Esra >(*-*)<
From: Roger Govier on 1 Apr 2010 03:50 Hi Eara Try this Sub Numbersheets() Dim i As Long, ws As Worksheet i = 1 Application.ScreenUpdating = False For Each ws In ThisWorkbook.Sheets ws.Range("B35") = i i = i + 1 Next Application.ScreenUpdating = True End Sub To Install Copy code above Alt+F11 to invoke the VB Editor Alt+I+M to insert a new module Paste code into White Pane that appears Alt+F11 to return to Excel To Use Alt+F8 to bring up Macros Select macro name Run -- Regards Roger Govier Esradekan wrote: > On Apr 1, 2:36 pm, Subodh <getsub...(a)gmail.com> wrote: >> You should use VBA code for this. >> As far as my knowledge goes Worksheets functions won't work. >> >> On Apr 1, 5:28 am, Esradekan <esrade...(a)gmail.com> wrote: >> >>> Hope someone can help. >>> How can I get one cell (B35) on each of 100 worksheets to number >>> consecutively? >>> TIA >>> Esra >>>> (*-*)<- Hide quoted text - >>> - Show quoted text - >> U should use VBA code. > > Thank you for the reply. Can you point me in the direction of how I > can get VBA code for this? > > TIA > Esra >> (*-*)<
From: Esradekan on 1 Apr 2010 06:02 On Apr 1, 8:50 pm, Roger Govier <ro...(a)technology4nospamu.co.uk> wrote: > Hi Eara > > Try this > > Sub Numbersheets() > Dim i As Long, ws As Worksheet > i = 1 > Application.ScreenUpdating = False > For Each ws In ThisWorkbook.Sheets > ws.Range("B35") = i > i = i + 1 > Next > Application.ScreenUpdating = True > End Sub > > To Install > Copy code above > Alt+F11 to invoke the VB Editor > Alt+I+M to insert a new module > Paste code into White Pane that appears > Alt+F11 to return to Excel > > To Use > Alt+F8 to bring up Macros > Select macro name > Run > > -- > Regards > Roger Govier > > > > Esradekan wrote: > > On Apr 1, 2:36 pm, Subodh <getsub...(a)gmail.com> wrote: > >> You should use VBA code for this. > >> As far as my knowledge goes Worksheets functions won't work. > > >> On Apr 1, 5:28 am, Esradekan <esrade...(a)gmail.com> wrote: > > >>> Hope someone can help. > >>> How can I get one cell (B35) on each of 100 worksheets to number > >>> consecutively? > >>> TIA > >>> Esra > >>>> (*-*)<- Hide quoted text - > >>> - Show quoted text - > >> U should use VBA code. > > > Thank you for the reply. Can you point me in the direction of how I > > can get VBA code for this? > > > TIA > > Esra > >> (*-*)<- Hide quoted text - > > - Show quoted text - Perfect, thank you Roger, most helpful Esra >(*-*)<
|
Pages: 1 Prev: Remove Last x Character(s) in Selected Cells Next: Range of values |