| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem getting cell value from range var
I am running the following test macro code to display content of the first
cell in a verticle single column named range that contains about 20 items and am getting a q=Error 2042 runtime 13 type mismatch error. How do I get the first cell content correctly? q = Range("jde_NewData")(1).Value MsgBox "x=" & q |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function problem regarding cell range | Excel Worksheet Functions | |||
| for each cell in range....direction problem | Excel Programming | |||
| cell vs range problem with formula | Excel Programming | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
| Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
Threaded Mode
