Thread
:
Creating Contigous Range from two ranges
View Single Post
#
2
Posted to microsoft.public.excel.programming
Mike H
external usenet poster
Posts: 11,501
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
Reply With Quote
Mike H
View Public Profile
Find all posts by Mike H