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.
What kind of values do E3, E4 and E5 contain?
- E3 & E4 are numeric and E5 alphanumeric.
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.
