Thread: Adding input to macro
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
cappuccine[_7_] cappuccine[_7_] is offline
external usenet poster
  
Posts: 1
Default Adding input to macro

awesome.. ok, another question. Now that I have the value from the input
box, I want to repeat the code again to do the same thing on a different
sheet. I changed rng to rng1 so I don't get a duplicate error. How do I
use the value from the input box again without having to ask for it
again?


--
cappuccine
------------------------------------------------------------------------
cappuccine's Profile: http://www.excelforum.com/member.php...o&userid=28242
View this thread: http://www.excelforum.com/showthread...hreadid=482267

Reply With QuoteReply With Quote