Dim c as Cell
Try:
DIM C As Range
A cell is a range containing only one cell.
"Keith Howard" wrote:
Hello.
I have an embarrassingly simple question. How do I declare a variable as a
Cell? The above line is not compiling.
I have set the following Tools | References:
Visual Basic For Applications
Microsoft Excel 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Object Library
I'm sure I have done this many times in the past successfully, but, for some
reason, it is not working now.
Thanks.
Keith
|