filling a table based on header row name

Hi,

Can you help me with the code below?
I'm trying to fill a status taken from column b and put it in a table
in between two time values. the first time value is

Please Login or Register  to view this content.

and
the second is

Please Login or Register  to view this content.

. In the table the times are held in row
1. The status will be sick or holiday etc, if the person is at work
they have a numeric duty code hence the isnumeric check. Once the
status has been filled to the time window, the next "c" in the range
is checked.

Please Login or Register  to view this content.

regards,
Matt

Matt,
Please wrap your code.
And it would help if you explained what is wrong with that code.

The condition in the Do..Loop doesn't change with each iteration of the loop. myOffset needs to be incorperated into the test for the Do.

Also,myOffset needs to be reset to 0 for each new row, lest the Do Loop start with the myOffset value from the last row.

If the Offset(0,1) value is present on Row1, but the Offset(0,2) is not, myOffset will increase without limit. A test to make sure that it exits should be added.

This worked for me.

Please Login or Register  to view this content.

You may want change the Do test to

Please Login or Register  to view this content.

in order to write to the column that matches the c.Offset(0,2).Value

I hope this helps.