I am trying to macro a code to return a value from a new tab that has just been created.
This is what I have so far, but it is returning as an error, I know why but I don't know how to resolve the issue.
ActiveCell.FormulaR1C1 = "=Sheets(ActiveWorkbook.Sheets.Count - 1).Select!R[1]C[4]"
Bookmarks