Code for oulining cell iff not empty,

[Frigide]

I wont a code to copy a row to another workbook in to columns. And then when a cell is not empty outline the cell.
This is what if have so far. How can i ad code for the oulining part?

Please Login or Register  to view this content.

[mehmetcik]

Use Conditional Formatting.

You do not need VBA for that





Select All Cells

Select the Home tab and then Conditional Formatting

Select New Rule and then "Use Formula to determine Format"

Enter this into the Formula Box

=A1<>""

Select Format and then choose your format





Use Pastespecial, Values, transpose

Please Login or Register  to view this content.

[Frigide]

Use Conditional Formatting.

You do not need VBA for that





Select All Cells

Select the Home tab and then Conditional Formatting

Select New Rule and then "Use Formula to determine Format"

Enter this into the Formula Box

=A1<>""

Select Format and then choose your format

Won't work because it wil also copy the format of the original cell. That has already a outline. But because it is copied fro vertical to horizontal the layout is not ok anymore, therefor i have to change the outline every time something is added.

[Frigide]

I find something. But this will freeze Excel. I think it is better to run a macro after the cells are copies.

Please Login or Register  to view this content.