Thanks guys! Problem solved.
--
Thanks a million,

Nick Junod


"John Michl" wrote:

Nick -
No macro is needed. I saw this method posted a week or two ago. This
is the other posting. (You may need to change references for your
situation.)

1. Place your cursor in cell A2.
2. Hold the Shift key down and then use PageDown and/or the Arrow keys,

etc., to highlight the complete data range.
3. From the menu, select Edit, Go To, Special, Blanks.
4. With the "funny" range selected, build a formula:
a. Press "=" and then the UP arrow.
b. Hold the CTRL key down and then press ENTER.

Voila! All of the blank cells now have a formula that evaluate to the
Company number above.

5. Copy the range and use Paste Special, Values to convert the formulas
to
values.

- John Michl (original poster was L. A. McClelland)