Range("TheOtherSheet!A" & x).Value = TheValue
syntax is:
<NameOfSheet!<CellAddress
Mind the *!*
:)
SystemHack Wrote:
Umm one more question, what is the string if the cell is in anothe
sheet
--
T-容
-----------------------------------------------------------------------
T-容x's Profile:
http://www.excelforum.com/member.php...fo&userid=2657
View this thread:
http://www.excelforum.com/showthread.php?threadid=39894