Forum Discussion
Solved
Move cursor to specific worksheet in Excel
If I have multiple worksheets (Jan to Dec & Main page) and in my main worksheet, user is allow to key in which month's worksheet to go to and error message popped up (type mismatch) when running the ...
If Tday (E3) and Tstore (E4) are numeric, Range(Tday & Tstore) is not valid.
For example if E3 = 12 and E4 = 37, Tday & Tstore would be "1237". Range("1237") results in an error.
If Tday (E3) and Tstore (E4) are numeric, Range(Tday & Tstore) is not valid.
For example if E3 = 12 and E4 = 37, Tday & Tstore would be "1237". Range("1237") results in an error.
Yeah, thanks for the advice, I've managed to solve it.