Thread: Using the value in the inputbox again
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
dok112[_72_] dok112[_72_] is offline
external usenet poster
  
Posts: 1
Default Using the value in the inputbox again

add

rng1.Offset(0, 4).Value = rng.Offset(0, 4).Value

after

rng1.Value = Dat

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=48236

Reply With QuoteReply With Quote