RefersToRange.Parent gives back an error(from book written by Bove
- From: "Richard" <Richard@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 13 Aug 2005 04:07:02 -0700
This is a piece off code from an APP (PETRAS Reporting)written by Bovey and
others for their book.
Y hope somebody will recognize it here.
The line off code "Set wksData.........."(see below) repeadedly gives back
an error.
The RefersToRange.Parent(Y do not completely understand it)
Y hope somebody can help me with this(maybe Bovey himself)
Because y sort off want to adapt the code to work with my own APP.
const sSOURCE As String = "ConsolidateWorkbooks"
On Error GoTo ErrorHandler
'Ask for a multi-select list of files to consolidate
vFiles = Application.GetOpenFilename("PETRAS Time*** Workbooks
(*.xls), *.xls", , "Selects Workbooks to Consolidate", "Consolidate", True)
'Exit if cancelled. As we asked for a multi-select list,
'we'll get an array returned if OK, or False of Cancelled,
'so we can test for the array (OK) case:
If Not IsArray(vFiles) Then Exit Sub
Application.ScreenUpdating = False
'Get the *** to write to
Set wksData = ActiveWorkbook.Names("rngDataArea").RefersToRange.Parent
Thanks,
Richard
.
- Follow-Ups:
- Re: RefersToRange.Parent gives back an error(from book written by Bove
- From: Dave Peterson
- Re: RefersToRange.Parent gives back an error(from book written by Bove
- Prev by Date: Re: How to display current row number in fixed cell?
- Next by Date: Create Add-ins
- Previous by thread: detect invalid cell reference
- Next by thread: Re: RefersToRange.Parent gives back an error(from book written by Bove
- Index(es):