| Home |
| Search |
| Today's Posts |
|
#24
Posted to microsoft.public.excel.programming
|
|||
|
|||
When found add it to the last and display total in Msgbox
Hi Howard,
Am Mon, 15 Sep 2014 03:32:37 -0700 (PDT) schrieb L. Howard: And since the array is 2D, both codes require at least two Names in col F? I tried one and it errors out on this line: no, a 2D array has two indices. One for the row and one for the column corresponding the reference with cells. A1 = cells(1,1) And the array works the same way. Step with F8 through your code and if the array is filled look into the watch window for the items and the indices. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MsgBox to display [hh]:mm | Excel Programming | |||
| Making a msgbox return a value in one cell, when data is searched and found in another. TIA | Excel Programming | |||
| Running total of Found Substrings in MainString in Big Loop | Excel Programming | |||
| How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
| If no FIND value is found, then a Msgbox to say so and exit sub | Excel Programming | |||
Threaded Mode
