| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Value to String?
I am trying to get a string from a cell value so that I can use indirect to
reference tabs. The tab names are in a column in tab "User Guide". I used the code: Dim tabName(0 To numWS - 1) As String tabName(0) = Worksheets("User Guide").Cells("E8").Value Whenever I try to run the macro. i get a "type mismatch" error. Can someone help me out? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| word match in string text in cell, color format cell | Excel Discussion (Misc queries) | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Programming | |||
| A Macro to replace a string in a cell with a string from another cell??? | Excel Programming | |||
| Create a formula into a String then assign string to a cell | Excel Programming | |||
Threaded Mode
