View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JavyD JavyD is offline
external usenet poster
 
Posts: 26
Default Input box Copy Paste Range

Hello all. I know a bit of vba, just lost a bit of it since I dont use it
much. This should be easy though

This is what I'm looking for. When the macro is launched, I want it to pop
up and ask for Range 1, that range is inputted, which is a range that
changes, that's why I want it to ask. Then ask for Range 2, that is
inputted, if they have to be done seperately, then fine. but once it ask, I
want it to copy range B3:B9 and paste it into the inputted range that I
entered into the input box. How's that, I knew it would be easy.