Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

strange formatting

Status
Not open for further replies.

bronc

Instructor
Aug 28, 2003
145
GB
If I apply this code to some numbers in A1:C5 they go bold as expected.
Worksheets("Sheet1").Range("A1:C5").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!
 
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top