D
DogLover
I am trying to run some VBA code that I would use Range names rather than a
specific range, ie Data!M3:M223.
MsgBox Evaluate("SUM( Data!M3:M223 )") will work, but when I change it to
include the Range name representing Data!M3:M223, it does not. Can anyone
help to figure out what I'm doing wrong. Thanks in advance.
Dim mTimeCriteria As String
Dim mPosition As String
Dim mFormula As String
Dim mQuestion1Range As Range
mTimeCriteria = "First day of employment (Time 1)"
mPosition = "Registered Nurse"
mPositionRange = Worksheets("Data").Range("DataPosition")
Set mTimeRange = Worksheets("Data").Range("DataTime")
Set mQuestion1Range = Worksheets("Data").Range("DataQuestion1")
MsgBox Evaluate("SUM( mQuestion1Range )")
specific range, ie Data!M3:M223.
MsgBox Evaluate("SUM( Data!M3:M223 )") will work, but when I change it to
include the Range name representing Data!M3:M223, it does not. Can anyone
help to figure out what I'm doing wrong. Thanks in advance.
Dim mTimeCriteria As String
Dim mPosition As String
Dim mFormula As String
Dim mQuestion1Range As Range
mTimeCriteria = "First day of employment (Time 1)"
mPosition = "Registered Nurse"
mPositionRange = Worksheets("Data").Range("DataPosition")
Set mTimeRange = Worksheets("Data").Range("DataTime")
Set mQuestion1Range = Worksheets("Data").Range("DataQuestion1")
MsgBox Evaluate("SUM( mQuestion1Range )")