View Single Post
  #1  
Old January 5th, 2004, 09:16 PM
external usenet poster
 
Posts: n/a
Default FILL CELLS = VARIABLE # OF OTHER CELLS (WITH MACRO)

COL A has variable number of cells...
Want to fill equal number of COL B cells with the number
70...

EXAMPLE:
If COL A has 8 cells, want only 8 cells of COL B with 70.
I don't want CELL 9 thru CELL X to have any values.

NEED THE MACRO CODING PLEASE.