How to let the cell name be the worksheet name in the macro code?

[Jesslynn]

I want the user to input their own sheet name in cell E2. From there, the macro must be able to grab the value of the input into the code. Can anybody help me. Thank you in advance!

this is the part that I'm stuck at


Dim x As Workbook

x.Sheets(Range(E2)).Rows(i).Columns("D")

 

[Michael M]

Do you mean

x.Sheets(Range("E2").value)

but what is this for ?

Rows(i).Columns("D")

Maybe you should post ALL of the code !!

 

[Jesslynn]

the user would write the sheetname of wkbk x in Cell E2
The macro in wkbk x must be able to select the sheetname that is written in E2

Dim x As Workbook
Dim y As Workbook
Set x = Workbooks.Open("")
Set y = Workbooks.Open("")

'From here i do not know the sheet name of the workbook but it is written in workbook x
'The next step I'm doing is copying the x file and paste it in y file

x.Sheets("???").Rows(1).Columns("G").Copy Destination:=y.Sheets("Sheet1").Rows(1).Columns("C")

The sheetname is in the excel sheet.


How do I let the Value in Cell E2 be the sheetname in macro without manually keying into the code above?