code name

Good day. I am opening an older version of the same document, copying some data from it, and adding it to the new document. I would like to use the sheet code name in the following line but when I do it comes back blank. What updates can I make? If I use the sheet position then this works but...

Trying to use sheet code names instead of sheet names, in case users change the sheet name, and the below returns the error "'Name' of object '_VBComponent' failed". Test2.Delete Worksheets.Add ws_name = ActiveSheet.Name...

I am trying to write a function that takes a cell's value, for example A1 = Sheet1, which is the codename of Sheet1, and return the worksheet name (which appears on the tab). So in Microsoft Excel Objects you have Sheet1 (HelloWorld) In cell A1 is the value Sheet1 In cell A2 I to write a...

Dear All, I am trying to have a simple copy paste code, using the line below while wbc & wbs different workbooks and Sheet1 is the code name of the target worksheet; wbc.Sheet1.Range("d4").Value = wbs.Sheet1.Range("d4").Value This above line is not working, however the one below, which...