Lots of people here help others out - I'm glad you found something
that works for you.

Pete

On Aug 6, 6:38 pm, Ross wrote:
Hey Pete!! I found an alternate way of doing what i wanted to... Tried it out
in bits and pieces and i think its good enough to suit my needs.....

Sub getsheetnames()
x = 1
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Worksheets("Sheet1").Cells(x, 2) = ws.Name + "!"
x = x + 1
Next ws
End Sub

And along with this, =INDIRECT(B1 & "A1").

I guess you would be familiar with this... You know i never expected anyone
to even consider helping me out.... Thanks a ton once again... :))