View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
williamr williamr is offline
external usenet poster
 
Posts: 14
Default Populating Cells using VBA

I have a small "Do While" VBA program that creates some numbers (4750). The
problem is that I don't know how to populate the cells in the worksheet using
the VBA code. My results look like the following:

Row 1 Unit 2 Shelf 4 Position 5

There are 4750 different combinations. I want to concatenate the number so
they look like 01-02-04-05 in Col A starting in row 3 until the Macro is
done, can someone help?

Thanks in Advance.