Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel and VBA Antony

Excel and VBA Antony

ResolvedVersion 2003

Wed 25 Jul 2012, 11:59 Delegate Robert said...

Robert has attended:
Project Introduction course
Project Intermediate course

Excel and VBA Antony

I am tryig to carry out conditional formatting in VBA. Colouring cells background when certain conditions are met.
When the macro is run through first time it works when run through again it returns "Run time Error '1004' Unable to set Color Index property of he interior class"
How do I stop this happening.

Wed 25 Jul 2012, 12:38 Trainer Anthony said...

RE: Excel and VBA Antony

Hi Robert. Are you protecting the worksheet? If so, have a look at this:

http://www.mrexcel.com/forum/showthread.php?17600-Setting-ColorIndex-On-Protected-Sheet

Hope this helps,

Anthony

Wed 1 Aug 2012: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips

Excel and VBA Antony

Excel and VBA Antony

RE: Excel and VBA Antony

Excel articles

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010