-Macros$$ Re: color coding of REPT function
Hi
Its not possible i guess..
But you can do with UDF..
for multiple fonts/colours etc in a single cell you use the
cells(x,y).characters(start,length).font function
The following code makes the first 10 characters BOLD and colour 56 and
Thanks a lot for that, I didn't thnik is possible but I needed to try.
Thanks
Pawel
From: Vabz
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Friday, September 21, 2012 2:01 PM
Subject: $$Excel-Macros$$ Re: color coding of REPT function
Hi
Its not possible i guess..
But you can do with UDF..
for multiple fonts/colours etc in a single cell you use the
cells(x,y).characters(start,length).font function
The following code makes the first 10 characters BOLD and colour 56 and the
rest not bold and colour 12
With Cells(row,col).Ch
