How to set up a macro that would use the active sheets names in the worksheets ?

Question

For instance : I have a file with a 100 worksheets, and in each sheet i need to have written " Whatever + active worksheet name" ?
Thanks

Answer 1

in english please!!!!

Answer 2

I'm not quite sure what you mean, but this may be part of your solution:

In Excel, you can link to other cells in other files using the following syntax:

=[FILENAME.xls]SHEET!CELL

So, if you have a file name "c:\file.xls", and a sheet called "Sheet1", and you want to link to cell A1, you should write the following in your cell:

='c:\[file.xls]Sheet1'!$A$1

You can also create this link automatically (without any coding) by opening both files, then from your first file, press '=' then link to your second file and select the cell of your choice. Press 'Enter' and you'll see the result in your cell.

Hope this helps!

Answer 3

This code will go through all the worksheets and put "Worksheets " in cell A1:

For i = 1 To Sheets.Count
Sheets(i).Select
Range("A1").Value = "Worksheet " & Sheets(i).name
Next i

Answer 4

The answer is in the question.

Rawlyn.

Answer 5

no