Select TAB Macro

[cfer]

Hi,

I have the following in a Macro, works fine, now I want to improve it a bit.

ThisWorkbook.Sheets("Details").Range("Q7").Value = Sheets("Data").Range("M27").Value

I have a user form that will give an option to select,several TAB names.

When selected, the name is entered into Sheet1 cell A1.

What code would I need, to have the line in "ThisWorkbook.Sheets("Details")" "Details" be whatever is selected from A1.

IE, If Cell A1 had "Misc", then the Misc would be selected

ThisWorkbook.Sheets("Misc").Range("Q7").Value = Sheets("Data").Range("M27").Value

The Sheets names can vary each time I run the Macro.

Thanks in advance

Cfer

 

[Sandeep Warrier]

You can store the value in A1 in a variable

for example

Dim stSheetName As String
 
 stSheetName = Range("A1").Value
 ThisWorkbook.Sheets(stSheetName).Range("Q7").Value

This should work.

 

[cfer]

Hi,
Worked fine

Thanks

Cfer