View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MachAngle MachAngle is offline
external usenet poster
 
Posts: 8
Default How to Bind VBA Variable to Range().Value2 Property

I want to use Excel VBA variables in modules and classes as "shorthand" for
the Range().Value2 property. I tried using declarations like:

Dim Variable As Double
Set Variable = Range("Cell Reference").Value2

Is there some way to use data binding in VBA to "link" a variable to a Named
cell property?