A Vb solution is what I'm looking for. What I mean by, and so on, is to
repeat the procedure any time the procedure (macro) finds another cell in
column B with a different initial until it finds the last initial and fills
until it reaches a blank cell. The cells between initials all contain F1.
Sorry I wasn't more explicit. I hope this explains my needs.

"Rick Rothstein" wrote:

Is a VB solution acceptable? Also, you need to tell us what you mean by "and
so on until all cells are filled". Does that mean the WZ will be filled all
the way down to the bottom of the worksheet (Row 65536)? If not, how do we
know when to stop copying down?

--
Rick (MVP - Excel)


"chrisnsmith" wrote in message
...
Imagine a worksheet that looks something like this:

cell B6 = WH
B40=WK
B55=WN
B73=WU
B88=WZ

The rows between these have no entries in column B. Is there a way to
fill
the cells between the WH and WK with WH, and cells between WK and WN with
WK
and so on until all cells are filled.