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.
|