| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Range
Hi,
I am trying to copy a range from one worksheet to another worksheet - in a macro. Is there anyway to save a range as a variable and then copy over the range. Like Dim Range1 as range Range1= Range("A1:A100").value Is there a good way to do this - right now I am using the copy paste command in the macro - but there probably is a better way. Thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy a specified name range | New Users to Excel | |||
| How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
| help with range copy | Excel Discussion (Misc queries) | |||
| copy a range without the same value | Excel Discussion (Misc queries) | |||
| Copy a range | Excel Worksheet Functions | |||
Threaded Mode
