| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Named range problem
I am trying to create a dynamic named range in my Workbook Open event and the
debugger tells me there is a problem. I can't figure it out. Any help would be appreciated. Dim sht As Worksheet sht = "My List" ActiveWorkBook.Names.Add Name:="KidsNames" RefersTo:=sht.Offset($A$1,0,0,CountA($A$A),5) Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating named range in VBA problem | Excel Programming | |||
| Problem creating a named range | Excel Programming | |||
| Problem with creating a named range | Excel Programming | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
| Creating a Named Range using VB | Excel Programming | |||
Threaded Mode
