Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box Copy Paste Range
Try something like
Dim Rng1 As Range Dim Rng2 As Range On Error Resume Next Set Rng1 = Application.InputBox(prompt:="Select a range.", Type:=8) If Rng1 Is Nothing Then Exit Sub End If Set Rng2 = Application.InputBox(prompt:="Select a range.", Type:=8) If Rng2 Is Nothing Then Exit Sub End If ' ' do the rest of your copy ' -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JavyD" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy range and paste into every 3rd cell of new range | New Users to Excel | |||
Drop Down--How do I copy and update cell link/input range | Excel Discussion (Misc queries) | |||
user input decides cell copy range | Excel Discussion (Misc queries) | |||
Copy/Paste Worksheet to last and rename with input box for value. | Excel Programming | |||
Copy/Paste Worksheet to last and rename with input box for value. | Excel Programming |