Jenst
09-21-2016, 05:35 AM
Hi, Does anyone has an idea, why I`m getting an error?? The input box is generating a number
Code:
dim exps as variant
dim Num as integer
exps = InputBox("Please input Experience column")
Num = Range(Cells(3, exps), Cells(3, exps).End(xlDown)).Count
Error:
Run-time error 1004
Application-defined or object-defined error
Thanks!! Jens
Code:
dim exps as variant
dim Num as integer
exps = InputBox("Please input Experience column")
Num = Range(Cells(3, exps), Cells(3, exps).End(xlDown)).Count
Error:
Run-time error 1004
Application-defined or object-defined error
Thanks!! Jens