| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating dymnamic named ranges
Hi:
I have a spreadsheet that contains a section I wish to import into Access. Because the amount of data (specifically the number of rows) varies, I wish to give the range a name, and I want to the name to refer to only those cells that contain data in column A. I know how to SELECT the range, BUT I do not know how to make that selected range into a named range, through programming. If someone could help me with this I would much appreciate it. Regards John Baker |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem creating named ranges in a Macro! | Excel Discussion (Misc queries) | |||
| Creating dynamic ranges which are named. | Excel Worksheet Functions | |||
| Named Ranges | Excel Worksheet Functions | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
| Creating Named Ranges in VBA | Excel Programming | |||
Threaded Mode
