| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to cobble together two bis of code (Unsuccessfully)
Hi Keith,
Thanks for responding :-) I don't think so I'm probably missing something really important Thanks anyway -- Deirdre "Keith74" wrote: Does using MsgBox cstr(MyPath) make a difference ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to cobble together two bis of code (Unsuccessfully)
Hi
The reason i said that is that the msgbox will only accept a variable it can display as a string, i'm guessing you're getting the "type mismatch" on the message box. Put a watch on myPath and step through the code to see what value myPath has. It looks like myPath is probably the wrong variable to be using. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to cobble together two bis of code (Unsuccessfully)
Hi Keith,
You are right Watch : : mypath : <Expression not defined in context : Empty : UnProtSheetsinBooksInFolder.unprotectshts I'm lost ! -- Deirdre "Keith74" wrote: Hi The reason i said that is that the msgbox will only accept a variable it can display as a string, i'm guessing you're getting the "type mismatch" on the message box. Put a watch on myPath and step through the code to see what value myPath has. It looks like myPath is probably the wrong variable to be using. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
| Testing (unsuccessfully) for non-blanks | Excel Programming | |||
| (Unsuccessfully!) Unhiding Rows in Excel 2003 | Excel Worksheet Functions | |||
Linear Mode
