Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range variables
I'm trying to copy and paste data from one sheet to another and thought it
would be useful to group a range rather than each cell and then paste. Am I able to create variables for ranges? I don't seem to be able to make it work. The code I've got is: Dim Cases as Range Cases = Range("B25,B27,B29,B30,B31").Value Range("B5").Select ActiveCell.Value = Cases That's with a few things cut out but you get the picture. Anyway, the macro is giving a 91 bug and stopping as the Cases = Range part. Any ideas would be very helpful. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range variables
No, you can't do anything like that. You could do
Range("B25,B27,B29:B31").copy Range("B5") -- Regards, Tom Ogilvy "carl" wrote: I'm trying to copy and paste data from one sheet to another and thought it would be useful to group a range rather than each cell and then paste. Am I able to create variables for ranges? I don't seem to be able to make it work. The code I've got is: Dim Cases as Range Cases = Range("B25,B27,B29,B30,B31").Value Range("B5").Select ActiveCell.Value = Cases That's with a few things cut out but you get the picture. Anyway, the macro is giving a 91 bug and stopping as the Cases = Range part. Any ideas would be very helpful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum a range based on two variables | Excel Worksheet Functions | |||
VBA Range Variables... | Excel Programming | |||
Set few range variables at once | Excel Programming | |||
Range of variables | Excel Programming | |||
Range Variables | Excel Programming |