| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating dymnamic named ranges
Thanks
Can you give me the exat syntax -- im not to good on VBA. Regards John Baker "Bob Phillips" wrote: John, Try a name with a RefersTo value of something like =Sheet1!$A$1:OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A: $A)-1,0) |
| 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
