| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping thru all rows with instr() test
Hi, I'm a VB6 developer, but I am battling to get to grips with this. I have a spreadsheet with two columns (A & B). In column A, is a folder name, embedded in which is the user name and in column B, is an amount. I need to loop for all rows, and starting in a fixed position in column A, derive the user name and put that in column C. However, the username is not fixed length. Can someone PLEASE help as I have been trying for a good few hours and not getting very far. Thanking you! -- Silvertip ------------------------------------------------------------------------ Silvertip's Profile: http://www.excelforum.com/member.php...o&userid=28456 View this thread: http://www.excelforum.com/showthread...hreadid=480586 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looping and stopping when a condition is met - test | Excel Discussion (Misc queries) | |||
| looping through rows and columns | Excel Discussion (Misc queries) | |||
| Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
| Looping a selection of rows | Excel Discussion (Misc queries) | |||
| Looping through visible rows only | Excel Programming | |||
Threaded Mode
