ActiveCell.Formula = "=+MyHiddenWorksheet!B2"

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"mwc0914" wrote:


I have a macro that references some data on a sheet I wish to have
hidden in my workbook. The macro abends because the sheet is hidden. Is
there some way to reference the hidden sheet in the macro so it will
execute?


--
mwc0914
------------------------------------------------------------------------
mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130
View this thread: http://www.excelforum.com/showthread...hreadid=558479