| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thank you very very much that works perfectly! I know practically nothing about Visual Basic, so I'm trying to understand this code... "If W.Name < sh_skip Then", how does this line make the program skip the summary worksheet? "If (IsNumeric(Range(VAL).Value) And Range(VAL).Value < "") Then", for this line, does the And Range(VAL).Value < "" make the code skip over the cells with no text in them, which the "" represents? Do these: < make the code skip what they are referring to? Sorry to keep bothering you, I just want to try and learn exactly how this code is working. Thanks, -Steve -- thephoenix12 ------------------------------------------------------------------------ thephoenix12's Profile: http://www.excelforum.com/member.php...o&userid=24336 View this thread: http://www.excelforum.com/showthread...hreadid=380524 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
