Copy cell formatting down a column

[zp162002]

Hello everyone. Is there an easy way to copy a cell's formatting properties (ex. align text in center of cell, change the fill color from white to green) down a column in Excel 97? I have some code that checks to see if there is a formula in the first cell in a range. If there is a formula, my code copies the formula down a specified number of rows. I want to include some code to copy the cell's formatting properites down the column as well. Thanks in advance.

PZ

 

[SkipVought]

Hi,

If you are COPYing cell(s) and Pasting, you will get formats unless you do something (ala Paste Special) to NOT.

???



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[zp162002]

Thanks Skip.