Help

[Matthew Leggett]

Hi I have two locations referenced by point1 = A5 point2 = A10 I need to use these variables in a calculation ie =sum(point1:point2) however this doesn't work? when I use this statement ActiveCell.Offset(0, 3).Value = "=sum(point1:point2) any work around / solution? if you require additional info let me know?

[Christian Graus]

Please don't ask twice. Please try to use intelligent headers. EVeryone here wants help. Please make it clear what you're asking about. Visual Basic.NET does not have any control which references locations by A5 and A10, or has an ActiveCell, It seems likely you're talking about Excel, but VBScript or interop ? How are we to tell ?

Christian Graus No longer a Microsoft MVP, but still happy to answer your questions.

[ChandraRam]

Matthew Leggett wrote:

I have two locations referenced by point1 = A5 point2 = A10 I need to use these variables in a calculation ie =sum(point1:point2) however this doesn't work? when I use this statement ActiveCell.Offset(0, 3).Value = "=sum(point1:point2) any work around / solution? if you require additional info let me know?

Try this: ActiveCell.Offset(0, 3).Value = "=sum(" & Point1 & ":" & Point2 & ")" This is of course assuming that you have Point1 and Point2 declared as strings.