Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

changing font colour arrays

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Changing Font Colour in Arrays

Changing Font Colour in Arrays

ResolvedVersion 2016

Changing Font Colour in Arrays

Is it possible to change font colour in an array?

I know this doesn't work, but I guess I'm looking for code along the lines of: myArray(RowNumber).Font.Color = RGB(192,192,192)

RE: Changing Font Colour in Arrays

Hi Andrew,

Thank you for the forum question.

No, arrays can only store text strings or numbers and not formatting, they will not store formatting information. The formatting is happen in the worksheet.






Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Changing Font Colour in Arrays

I thought that was the case.

Thanks for the quick reply!

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.