| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
fighting the type mismatch error
This is by no means a fix, but in the future, I've found it easier t
reference worksheets by their sheet number. In the VB Editor, the upper left window (Project Explorer) lists th sheet by name, then by number in parenthesis (SheetX). Instead o Worksheets("sheet2").Range("B15"), you can use Sheet2.Range("B15").. unless of course, your sheet has a different number. -Gitcyphe -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| Type Mismatch Error | Excel Discussion (Misc queries) | |||
| Help with Error: Type Mismatch | Excel Programming | |||
| Type Mismatch Error | Excel Programming | |||
| Type Mismatch Error Need Help | Excel Programming | |||
![gitcypher[_24_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
