Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel - Background Patterns
Message
 
 
Information générale
Forum:
Visual Basic
Catégorie:
VBA
Divers
Thread ID:
00249417
Message ID:
00251811
Vues:
16
>Using VBA in Excel what is the property to change the background pattern. Excel.stuff.CellOrRange.????? Thanks.

Selection.Interior.Pattern = xlSolid ' or xlcheckered ... etc

This is the answer if anyone else was interested. Guy Barret actually answered me in a much earlier post and had I paid attention then I would have known. :)

Thanks Guy.
~Joe Johnston USA

"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform