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" wrote in message
...
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*