ExcelBanter - Formula Referencing Worksheet Name by Variable

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula Referencing Worksheet Name by Variable (https://www.excelbanter.com/excel-programming/306048-re-formula-referencing-worksheet-name-variable.html)

Soo Cheon Jheong[_2_]

Formula Referencing Worksheet Name by Variable

Hi,

Sub TEST()

With ActiveSheet
.Range("B2").Formula = "='" & Sheets.Add.Name & "'!A7"
.Activate
End With

End Sub

--
Regards,
Soo Cheon Jheong
_ _
^ ^
V

All times are GMT +1. The time now is 06:05 AM.