Is there a neat way of saying "fill cells A1 to A12 with dashes (-)" ?
If so ... can someone enlighten me ... thanks a lot !
Printable View
Is there a neat way of saying "fill cells A1 to A12 with dashes (-)" ?
If so ... can someone enlighten me ... thanks a lot !
VB Code:
Dim rngOrange As Range Set rngOrange = ThisWorkbook.Worksheets("Test").Range("A1:A12") rngOrange.Value = "-"
See ... I knew there would be !
Cheers Kenny :)
Actually thats not "quite" what I had in mind .. but its close enough for me to use.
What I was after was the entire cell to be filled with "-" characters, so when I set a range it would give me a continuous dotted line, but I can use what you gave me as its neater than what I had.
If you need a continuous dotted line, why don't you use the borders of the range?
That would be the most sensible idea ... but I've just realised the problem I've got with this is that all the lines are "drawn" as the entire shooting match is imported into Excel from a text file !
I had a problem where if I added one too many suddenly the line looked miles bigger when dumped in Excel.
Its all very crude (and pretty naff to be honest), so I'm not going to waste any more time with it. They can live with it !