Hi there. Need some help please.
I would like to get some code that will fill blanks in a range.
Forgive me if I have not used the board facilities properly. In the following table I need each blank cell in column B to be filled with the text from the preceding cell that has text in it.
i.e. B2 to be populated with "text1". Cells B4:B6 to be populated with "text2".
The code needs to know that row 9 is the last row to populate.
Thanks in advance
<TBODY>
</TBODY>
I would like to get some code that will fill blanks in a range.
Forgive me if I have not used the board facilities properly. In the following table I need each blank cell in column B to be filled with the text from the preceding cell that has text in it.
i.e. B2 to be populated with "text1". Cells B4:B6 to be populated with "text2".
The code needs to know that row 9 is the last row to populate.
Thanks in advance
A | B | |
1 | head | text1 |
2 | acc | |
3 | head | text2 |
4 | acc | |
5 | fry | |
6 | oth | |
7 | head | text3 |
8 | acc | |
9 | oth | |
10 |
<TBODY>
</TBODY>