Reply to thread

Message: [QUOTE="Werner Rohrmoser, post: 6443179"] Hi, I have a table, which is downloaded from SAP and has no formulas. The identifier of the rows is a project item number like "PRD. 00133.07-03-04" and I count the number of "." and "-" with a formula to get the level of the project item. My goal is now to make an outline by vba using the level numbers, e.g. 4 in the case described above. The first row of the table is poulate with these level numbers like 1 2 2 3 3 2 1 2 and so on. Does anyone have a vba procedure to solve this problem. Thanks. Excel XP SP3 Windows XP SP3 Best Regards Werner [/QUOTE]