Hi Gleam

Sorry, I didnt explain myself well. The reference in there (Range("A5:D5"))
was the original example only, what I needed was lots of named ranges (around
40)to take their place. From what I can work out, the merge seems to want
just one range.
Regards
Andrew

"Gleam" wrote:

Does this help?:
SourceRng:=Range("A5:D5")
Set sourceRange = Range("A1:C1")

"Andrew P." wrote:

Hi All

Im strugling to get the merge code to work with multiple named ranges. I
want to collate info from lots of forms. The forms have named ranges in them,
which are scattered throughout the form. Ive tried loads of different ways of
reffering to the ranges, but just cant make it work.

Original pieces of code: SourceRng:="A5:D5", _
also from another file, the piece of code is Set sourceRange = .Range("A1:C1")

Any help would be greatly appreciated!
Thanks
Andrew