Excel

trasher
07-16-2001, 08:36 AM
Can I declare a variable's name for the content of a specific cells? So I will be able to refer to this name instead of a cells.
I heard that it was possible to do this.

BlueRaja
07-17-2001, 02:14 AM
Hi,

I know you can do this sort of thing using a range ...

Sub Main()
Dim rngTest As Range
Set rngTest = Cells(1, 1)
MsgBox rngTest.Value
End Sub

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum