excel - How to add times in VBA? Getting Type Mismatch -


below of code in i'm trying add time value part of loop. sheet parámetros has cell b1 accepts times (i made sure using data validation tool). i'm confused why keep getting error of "type mismatch." want convert time string can concatenate text, , i'm not sure how either.. appreciated :)

sheets("parámetros").range("b1").value = sheets("parámetros").range("b1").value + time(0, 5, 0) 

replace:

time(0, 5, 0) 

with:

timeserial(0, 5, 0) 

Comments

Popular posts from this blog

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

javascript - oscilloscope of speaker input stops rendering after a few seconds -