| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using a named range in a header with VBA?
I'd like to apply a named range to headers in a file. I did a search
and found some syntax that is close, but still generating an error. The named range is "DollarVal". The code I have is ActiveSheet.PageSetup.RightHeader = "Total: " & Range(DollarVal) Any thoughts? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| named range with filter | Excel Worksheet Functions | |||
| Passing Excel NAMED Range to VBA | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Threaded Mode
