What has changed?

> Dim cl As Cell *This no longer compiles / works*

There is no object in Excel named "Cell". Use "Range" instead.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jack" <Jack@discussions.microsoft.com> wrote in message
news:4169D925-DCAD-49C9-A32A-670125CAC2BD@microsoft.com...
>I am using the excell 10 lib from MS Access to reference excel
>worksheets.
> My code, which worked in previous incarnations, now falls over!
> The lib no
> longer recognises CELL or CELLS, any clues?
>
> Dim objXL As Object ' Variable to hold reference to Microsoft
> Excel.
> Dim wkbXLBook As Excel.Workbook
> Dim wksSheet As Excel.Worksheet
> Dim ExcelWasNotRunning As Boolean ' Flag for final release.
> Dim r As Excel.Range
>
> Dim cl As Cell *This no longer compiles / works*

Thanks guys, never thought of applying a single cell range as a pointer to an
individual cell ie (a1:a1) was too busy looking for reasons why something
that worked in a previous incarnation failed!

"Chip Pearson" wrote:

> > Dim cl As Cell *This no longer compiles / works*
>
> There is no object in Excel named "Cell". Use "Range" instead.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Jack" <Jack@discussions.microsoft.com> wrote in message
> news:4169D925-DCAD-49C9-A32A-670125CAC2BD@microsoft.com...
> >I am using the excell 10 lib from MS Access to reference excel
> >worksheets.
> > My code, which worked in previous incarnations, now falls over!
> > The lib no
> > longer recognises CELL or CELLS, any clues?
> >
> > Dim objXL As Object ' Variable to hold reference to Microsoft
> > Excel.
> > Dim wkbXLBook As Excel.Workbook
> > Dim wksSheet As Excel.Worksheet
> > Dim ExcelWasNotRunning As Boolean ' Flag for final release.
> > Dim r As Excel.Range
> >
> > Dim cl As Cell *This no longer compiles / works*
>
>
>

I fail to see how it could have worked in a previous incarnation, cell is
not a object data type.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack" <Jack@discussions.microsoft.com> wrote in message
news:808576CF-4BDC-408E-AC50-5C08BF908D37@microsoft.com...
> Thanks guys, never thought of applying a single cell range as a pointer to
an
> individual cell ie (a1:a1) was too busy looking for reasons why something
> that worked in a previous incarnation failed!
>
> "Chip Pearson" wrote:
>
> > > Dim cl As Cell *This no longer compiles / works*
> >
> > There is no object in Excel named "Cell". Use "Range" instead.
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
> > "Jack" <Jack@discussions.microsoft.com> wrote in message
> > news:4169D925-DCAD-49C9-A32A-670125CAC2BD@microsoft.com...
> > >I am using the excell 10 lib from MS Access to reference excel
> > >worksheets.
> > > My code, which worked in previous incarnations, now falls over!
> > > The lib no
> > > longer recognises CELL or CELLS, any clues?
> > >
> > > Dim objXL As Object ' Variable to hold reference to Microsoft
> > > Excel.
> > > Dim wkbXLBook As Excel.Workbook
> > > Dim wksSheet As Excel.Worksheet
> > > Dim ExcelWasNotRunning As Boolean ' Flag for final release.
> > > Dim r As Excel.Range
> > >
> > > Dim cl As Cell *This no longer compiles / works*
> >
> >
> >