ExcelBanter - Cell Reference is Worksheet Name in VB Code

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

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

- - Cell Reference is Worksheet Name in VB Code (https://www.excelbanter.com/excel-programming/331407-re-cell-reference-worksheet-name-vbulletin-code.html)

mangesh_yadav[_275_]

Cell Reference is Worksheet Name in VB Code

Set Summary = Worksheets(Range("B3"))

or

Set Summary = Worksheets(worksheets("Sheet_name").Range("B3"))

Mangesh

--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=377971

All times are GMT +1. The time now is 09:51 PM.