singel cell reference
The default property for the range object is Value, so in most cases,
you can use Range("D1") directly
a = Range("D1") * 10
As you get deeper into VBA, you may hit cases where Range("D1").Value
is specifically needed.
Carl.
On Apr 16, 4:20 am, "Norman Jones"
wrote:
Hi Guye,
'-------------------
how do i make a reference to a single specific cell (for example D1)
in a amcro
'-------------------
I suspect that there may be more to your question than
is immediately apparent, but try something like:
'=============
Public Sub Tester()
Dim rng As Range
Set rng = Range("D1")
MsgBox rng.Address(0, 0)
End Sub
'<<=============
---
Regards,
Norman
|