Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rond merge help
Hi All
Im trying to make the example 1 work from Copy3, but Im having trouble referring to multiple named ranges - most I can get to work is one named range (always only 1 [merged] cell). Whats the correct method? - Set sourceRange = .Range("") Also, is there a way to get the names of the ranges into row 1? Thanks a heap Andrew |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rond merge help
To get range names into row 1, try:
Sub NameLister() Dim n As Name i = 0 For Each n In ThisWorkbook.Names Range("A1").Offset(0, i).Value = n.Name i = i + 1 Next End Sub -- Gary''s Student - gsnu200901 "Andrew P." wrote: Hi All Im trying to make the example 1 work from Copy3, but Im having trouble referring to multiple named ranges - most I can get to work is one named range (always only 1 [merged] cell). Whats the correct method? - Set sourceRange = .Range("") Also, is there a way to get the names of the ranges into row 1? Thanks a heap Andrew |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ron merge help
Hi Gary
Sorry, I dont follow it - is this meant to sit in the merge macro? FYI the code Im using is from http://www.rondebruin.nl/copy3.htm Thanks Andrew "Gary''s Student" wrote: To get range names into row 1, try: Sub NameLister() Dim n As Name i = 0 For Each n In ThisWorkbook.Names Range("A1").Offset(0, i).Value = n.Name i = i + 1 Next End Sub -- Gary''s Student - gsnu200901 "Andrew P." wrote: Hi All Im trying to make the example 1 work from Copy3, but Im having trouble referring to multiple named ranges - most I can get to work is one named range (always only 1 [merged] cell). Whats the correct method? - Set sourceRange = .Range("") Also, is there a way to get the names of the ranges into row 1? Thanks a heap Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge macro: select recipients from Excel during merge | Excel Programming | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
Roud up or rond down | Excel Discussion (Misc queries) | |||
Merge =( formula should retain fraction type numbers after merge. | Excel Worksheet Functions | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |