Ardus Petus Wrote:
I got your file, thank you.

Problems start with question 10 (CE1): it contains the word "please
but has
NO bold (<btext</b) text.
Since it has no bold text, I can ignore it and skip to next colum
header.Correct - since there is no bold text, this would be where the dat
parsing would stop.

Ardus Petus Wrote:
CF1 contains both "please" and bold text (Clerical Staff). Si I should
consider it as a question, exprecting results in next column.
No. I want to stop the parsing once Question 9 has been reviewed. Th
only problem is, sometimes this file's Question 9 may appear as Questio
8 on another file I wish to run the macro on.

Ardus Petus Wrote:
Column cg contains bold text. Since it comes immediately after
quetion, I
consider the bold text as the name of the respondent.
This and all following columns can be disregarded for the macro.

Ardus Petus Wrote:
Considering these problems, I suggest we parameterize the macro so tha
it
considers a definite number or columns, ignoring all extra columns.

Do you agree?
Hopefully, the answers above make it easier to identify the stoppin
point for the macro.

--
A

--
ebachen
-----------------------------------------------------------------------
ebachenh's Profile: http://www.excelforum.com/member.php...fo&userid=3237
View this thread: http://www.excelforum.com/showthread.php?threadid=52130