Thanks for the help with this, it gets the idea across, which is what
need. I still seem to have some issues formulating the same thin
within vba, though. This is what I have thus far:


Set rng = Cells(Rows.Count, 1).End(xlUp)

Worksheets("_DeputationQuery").Range("F1").Activat e
For i = 1 To rng.Row
ActiveCell.Formula = "=REPT(""|"",E" & i & "*100)"
ActiveCell.Offset(1, 0).Select
Next i


The error I receive is from the "ActiveCell.Formula" line. If you ca
help me finish this off, a director at my office will definitel
appreciate it!

Jef

--
Message posted from http://www.ExcelForum.com