W
White Buddah
Guest
I'm trying to figure out how to write a macro for an entire column. I've got it for a single cell. The bad thing is that it will still take forever to get thru the entire column. Here is what I have so far:
Sub formatcell()
ActiveCell.Characters(Start:=1, Length:=13).Font.Color = -16776961
End Sub
Now I just need the whole column to do this.
Any help, or the macro itself, would be great!!
Sub formatcell()
ActiveCell.Characters(Start:=1, Length:=13).Font.Color = -16776961
End Sub
Now I just need the whole column to do this.
Any help, or the macro itself, would be great!!
