Gathering sheet names and displaying them in a specific sheet column

Hi,

I want to display my results in a Cell/column in a specific sheet(test) on a button click.

I have this piece of code below. Which is giving the names of all visible sheets but i need them to go to a specific place in that sheet.

Dim ws As Worksheet, ws1 As Worksheet
Set ws1 = Sheets("Test")
i = 1

Please Login or Register  to view this content.

Any help would be much appreciated.

Many thanks

LePig, so you are saying the code works but the names are being put in the wrong place? where do you want them to go?

If the rows are ok but you want to change the column then this line:

Please Login or Register  to view this content.

needs to change. The 1 in "(i,1)" represents the column (A), so just change that number to the column you want (B is 2, C is 3, and so on)

i need them to go to a specific place in that sheet

I'm guessing you mean your list of sheet names. Whereabouts do you want the list to go?
ws1.Cells(i, 1) allows you to choose the start row and column.