Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 28th 07, 05:19 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 151
Default list sheet names vertically below the active cell - need macro.

I am having at least 45 sheets in few of my workbooks which i get daily, so
it is very difficult to find which sheet is missing. a simple macro to list
sheets would help a lot.
please....

I need all the sheet names in the active workbook, listed one below the
other.

Like if my active cell is c25, then when i run the macro, it must list all
the sheet names below c25 starting from c25 to c70 (45 sheet names)

i would like to put this macro in a control button.

if i could get this code before 1st october, will be much obliged.

if possible give to horizontally also, c25,d25,e25...

Eddy Stan

  #2   Report Post  
Old September 28th 07, 05:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default list sheet names vertically below the active cell - need macro.

Try this:

Sub eddy_current()
Set r = ActiveCell
For i = 1 To Worksheets.Count
r.Offset(i - 1, 0).Value = Sheets(i).Name
Next
End Sub

If this is what you want, just make a button from the Forms toolbox and
assign the macro to the button.
--
Gary''s Student - gsnu200747


"Eddy Stan" wrote:

I am having at least 45 sheets in few of my workbooks which i get daily, so
it is very difficult to find which sheet is missing. a simple macro to list
sheets would help a lot.
please....

I need all the sheet names in the active workbook, listed one below the
other.

Like if my active cell is c25, then when i run the macro, it must list all
the sheet names below c25 starting from c25 to c70 (45 sheet names)

i would like to put this macro in a control button.

if i could get this code before 1st october, will be much obliged.

if possible give to horizontally also, c25,d25,e25...

Eddy Stan

  #3   Report Post  
Old September 28th 07, 07:48 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 6,953
Default list sheet names vertically below the active cell - need macro

Put a couple of chart sheets intermingled with the worksheets and run this.

--
Regards,
Tom Ogilvy




"Gary''s Student" wrote:

Try this:

Sub eddy_current()
Set r = ActiveCell
For i = 1 To Worksheets.Count
r.Offset(i - 1, 0).Value = Sheets(i).Name
Next
End Sub

If this is what you want, just make a button from the Forms toolbox and
assign the macro to the button.
--
Gary''s Student - gsnu200747


"Eddy Stan" wrote:

I am having at least 45 sheets in few of my workbooks which i get daily, so
it is very difficult to find which sheet is missing. a simple macro to list
sheets would help a lot.
please....

I need all the sheet names in the active workbook, listed one below the
other.

Like if my active cell is c25, then when i run the macro, it must list all
the sheet names below c25 starting from c25 to c70 (45 sheet names)

i would like to put this macro in a control button.

if i could get this code before 1st october, will be much obliged.

if possible give to horizontally also, c25,d25,e25...

Eddy Stan



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to find cell content in sheets and make sheet active Nigel Excel Discussion (Misc queries) 4 June 26th 14 02:38 PM
copy name from active sheet to cell - using macro or function dymek Excel Worksheet Functions 2 October 2nd 06 12:32 PM
Active Cell Copy And Paste Sheet to Sheet A.R.J Allan Jefferys New Users to Excel 4 May 4th 06 02:04 AM
how do i set up a list of names on a sheet frm various sheets in e mcvities_69 Excel Discussion (Misc queries) 1 January 27th 06 03:51 AM
How to change macro so it performs actions on ACTIVE sheet? Tom9283 Excel Discussion (Misc queries) 6 April 15th 05 07:32 AM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017