Creating Contigous Range from two ranges
I have two ranges:
$A$1 and $A$10 How do I bring them together to become a contiguous range. Union will create: A1, A10 I want A1:A10. Thanks EM |
Creating Contigous Range from two ranges
Try
Set myrange = Range("A1:A10") Mike "ExcelMonkey" wrote: I have two ranges: $A$1 and $A$10 How do I bring them together to become a contiguous range. Union will create: A1, A10 I want A1:A10. Thanks EM |
Creating Contigous Range from two ranges
Yeah thats it. I got my wires crossed and assumed it was more difficult than
that. Thanks EM "Mike H" wrote: Try Set myrange = Range("A1:A10") Mike "ExcelMonkey" wrote: I have two ranges: $A$1 and $A$10 How do I bring them together to become a contiguous range. Union will create: A1, A10 I want A1:A10. Thanks EM |
All times are GMT +1. The time now is 02:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com