paradox34690
10-22-2012, 12:16 AM
Greetings!
I'm working on some VBA for Excel 2003 currently and am having a bugger of a time with something. I'm trying to add the following:
jCell = "09/24/2012 16:42:02"
eCell = "30" which is to represent 30 seconds.
My original equation is:
AnalysisWorkssheet.Range(dCell).Value = AnalysisWorksheet.Range(jCell).Value + Time(0, 0, AnalysisWorksheet.Range(eCell).Value)
dCell = where I need it to go and in this example it should be "09/24/2012 16:42:32"
I'm getting a <Type Mismatch> on the Time() portion, however when in debug mode, when I hover over the 'eCell' portion of the equation it IS showing the desired value that I would like added to "jCell".
Anyone have any thoughts? I've been scouring the internet for several days on this one and have been mainly fruitless....
THANKS!
Any thoughts or suggestions?
I'm working on some VBA for Excel 2003 currently and am having a bugger of a time with something. I'm trying to add the following:
jCell = "09/24/2012 16:42:02"
eCell = "30" which is to represent 30 seconds.
My original equation is:
AnalysisWorkssheet.Range(dCell).Value = AnalysisWorksheet.Range(jCell).Value + Time(0, 0, AnalysisWorksheet.Range(eCell).Value)
dCell = where I need it to go and in this example it should be "09/24/2012 16:42:32"
I'm getting a <Type Mismatch> on the Time() portion, however when in debug mode, when I hover over the 'eCell' portion of the equation it IS showing the desired value that I would like added to "jCell".
Anyone have any thoughts? I've been scouring the internet for several days on this one and have been mainly fruitless....
THANKS!
Any thoughts or suggestions?