Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Howard Dixon on Nov 18 In MS Office Category.

Basic Cell manipulation by code

Question Answered By: Della Simpson on Nov 18

Cell alignment is .HorizontalAlignment = 3 (for centered).
Randy, your link was helpful in seeing a list of the
constants (such as xlCenter).

As for backcolor, it is .Interior.Color=RGB(200,200,200),
to do light grey, for example.

This Question has 3 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Basic Cell manipulation by code Or get search suggestion and latest updates.

Related Topics:

Copying current cell's value to another cell
A very basic excel question about protecting cells
Function needed to split the content of a cell into many cells
Moving data in the last cell of row to another column cell
Action taken by Excel when a condition causes a cell's value
Function needed to split the content of a cell intomany cells
how are cell coordinates referenced on a clicked cell
to see if text in a cell in a column is contained in any cell
A Paragraphs in one cells --> convert into a line in per cells
Cell validation based on the contents of previous cell
Finding and replacing the cell next to a cell with a certain string
Copy Value produced by formula in cell C3 to cell D3
Update a cell based on a DDE updated cell value
active cell no longer advances to cell below
Copy cell contents to same cell on different worksheet if contains
Code not updating cell value
VBA code to add values in two cells which have formulas
Need help with code to find data within a cell
Vb code to transfer cells text to text box
This code does not work if i copy & paste above one cell

Tagged:basic cell manipulation by code

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us