T treehook New Member Joined Messages 2 #1 Hello, Sorry if this a basic question, I'm learning vba and have WORKSHEETNAME in cell A1, it is also the name of a tab in my workbook I'm not sure what the code is to get the value of cell A1 and make it into a worksheetSyntax =CELL ("filename",A1) "filename" gets the full name of the sheet of the reference cell A1 Sheet's cell reference But we need to extract just the sheet name Basically the last name As you can see the sheet name starts after (closed big bracket sign) For that we just needs its position in the text and then we will extract Read or Get Data from Worksheet Cell to VBA in Excel – Solution(s) MsgBox Cells(1, 1) 'Here the first value is Row Value and the second one is column value 'Cells(1, 1) means first row first column End Sub In this example I am reading the data from first row and fourth column of the worksheet Sub sbGetCellData1() MsgBox Cells(1, 4) End Sub Here is sample picture,
Excel Magic Trick 1107 Vlookup To Different Sheet Sheet Reference Defined Name Table Formula Youtube
