strange formatting

[bronc]

If I apply this code to some numbers in A1:C5 they go bold as expected.
Worksheets("Sheet1&quot.Range("A1:C5&quot.Font.Bold = True
The problem is that if I now type into a cell below - C6 for example it is now bold! (Using XP).
Of course I made sure that there was no formatting previously in place by Edit Clear Formatting. Try it!

 

[SQLBI]

Bronc,

I think Excel 2000 and XP use what i call predictive formatting.

If you apply formats to a particular range and then type similar data or formulas beneath it, it tries to help you out by repeating the formats. Helpful sometimes, but not in your case.

There should be something in Tools > Options to enable/diable this function.

Hope this helps.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[xlbo]

Tools>Options>Edit
untick "Extend list formats and formulas"
to be precise...

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[SQLBI]

Touche Geoff!!


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[bronc]

i am most grateful

 

[xlbo]

Sorry Leigh - couldn't help myself

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244