General information
Category:
COM/DCOM and OLE Automation
>Hello,
>
>I have several questions about Automation in Excel.
>
>1. I'd like to know how I can change the background and foreground color of a cell?
>
>2. How can I insert a new column?
>
>3. How can I print the same header on every page when I print my Excelsheet?
>
The best way to answer questions like this yourself is to record a macro doing the task interactively and then examine it to see what objects and properties it uses. In addition, the Excel VBA Help file will give you lots of information.
For your first question, check out the Font object.
To insert a column, look at the Insert method.
For the last question, check out the PageSetup object, in particular, the xxxHeader and xxxFooter properties.
Tamar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only