All worksheet names on summary page

**sachinahj** · 07-26-2012, 02:50 PM

Hi everyone,

I want to put all the worksheet names besides my 'summary' one (which is first) on the 'summary' worksheet starting from cell c1 and then going to d1..e1..f1..etc. The problem is, that I dont know how many worksheets I have and people will be adding and deleting the worksheet tabs.

I have this code but it populates the names going down a column but i want to go across columns:

Please Login or Register  to view this content.

Any help is appreciated!!

**xladept** · 07-26-2012, 02:59 PM

Try this if you're still looking:

Please Login or Register  to view this content.

**arlu1201** · 07-26-2012, 03:00 PM

Sachin,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

**sachinahj** · 07-26-2012, 03:05 PM

Thanks!

Yea i looked at it after and saw that i could just switch the count,1 -- just started using vba for the first time and this website has been helpful in finding random code and just manipulating it.

I have another question.. Under those "sheet name" columns, each cell has a function that looks like this:

Please Login or Register  to view this content.

Now is there any way that I can change that 'Sheet1' to be the exact text in the upper most cell of that column which essentially is the sheet name because of my vba code. I want to do this just in case someone changes the order of the worksheet tabs.

Thanks