Click here to Skip to main content
15,914,419 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionThread count keeps increasing Pin
alexvw15-Aug-08 16:31
alexvw15-Aug-08 16:31 
AnswerRe: Thread count keeps increasing Pin
N a v a n e e t h15-Aug-08 18:12
N a v a n e e t h15-Aug-08 18:12 
GeneralHere is the code! [modified] Pin
alexvw16-Aug-08 1:11
alexvw16-Aug-08 1:11 
Question[Message Deleted] Pin
Matthew Leggett15-Aug-08 16:10
Matthew Leggett15-Aug-08 16:10 
AnswerRe: is it possible Pin
Christian Graus15-Aug-08 18:07
protectorChristian Graus15-Aug-08 18:07 
QuestionHelp Pin
Matthew Leggett15-Aug-08 15:46
Matthew Leggett15-Aug-08 15:46 
AnswerRe: Help Pin
Christian Graus15-Aug-08 18:09
protectorChristian Graus15-Aug-08 18:09 
AnswerRe: Help Pin
ChandraRam17-Aug-08 21:01
ChandraRam17-Aug-08 21:01 
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.
QuestionDateTime and Time Zones Pin
nlarson1115-Aug-08 9:38
nlarson1115-Aug-08 9:38 
AnswerRe: DateTime and Time Zones Pin
Mycroft Holmes15-Aug-08 15:26
professionalMycroft Holmes15-Aug-08 15:26 
QuestionVB Code problem Pin
romance115-Aug-08 9:10
romance115-Aug-08 9:10 
AnswerRe: VB Code problem Pin
Mycroft Holmes15-Aug-08 15:23
professionalMycroft Holmes15-Aug-08 15:23 
GeneralRe: VB Code problem Pin
romance117-Aug-08 12:39
romance117-Aug-08 12:39 
GeneralRe: VB Code problem Pin
Mycroft Holmes17-Aug-08 14:06
professionalMycroft Holmes17-Aug-08 14:06 
Questioncreate new variable in Run time Pin
shee_dee8615-Aug-08 3:25
shee_dee8615-Aug-08 3:25 
AnswerRe: create new variable in Run time Pin
Manas Bhardwaj15-Aug-08 4:02
professionalManas Bhardwaj15-Aug-08 4:02 
AnswerRe: create new variable in Run time Pin
Paul Conrad15-Aug-08 6:21
professionalPaul Conrad15-Aug-08 6:21 
AnswerRe: create new variable in Run time Pin
dan!sh 15-Aug-08 6:53
professional dan!sh 15-Aug-08 6:53 
AnswerRe: create new variable in Run time Pin
Guffa17-Aug-08 21:34
Guffa17-Aug-08 21:34 
QuestionExtended Table Adapters for Dynamic SQL Pin
The_Funkster_Deluxe15-Aug-08 3:18
The_Funkster_Deluxe15-Aug-08 3:18 
AnswerRe: Extended Table Adapters for Dynamic SQL Pin
Jon_Boy15-Aug-08 3:37
Jon_Boy15-Aug-08 3:37 
GeneralRe: Extended Table Adapters for Dynamic SQL Pin
The_Funkster_Deluxe15-Aug-08 3:44
The_Funkster_Deluxe15-Aug-08 3:44 
GeneralRe: Extended Table Adapters for Dynamic SQL Pin
Jon_Boy15-Aug-08 3:48
Jon_Boy15-Aug-08 3:48 
GeneralRe: Extended Table Adapters for Dynamic SQL Pin
The_Funkster_Deluxe15-Aug-08 3:53
The_Funkster_Deluxe15-Aug-08 3:53 
GeneralRe: Extended Table Adapters for Dynamic SQL Pin
Jon_Boy15-Aug-08 4:15
Jon_Boy15-Aug-08 4:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.