Creating a custom cell pattern in Excel??

[JTD1]

Is it possible to create a custom cell pattern in Excel? For example, I would like to create a modified pattern of the horizontal stripe, where there is only one stripe in the middle of the cell.

Possible or Not??????

 

[SkipVought]

JTD1,

I know of no way to design a custom pattern.

What is the business case for this requirement?

Skip,

http://www.TheOfficeExperts.com

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

 

[DrBowes]

Don't really know any way to add custom patterns, but here are some ideas.

For a horizontal line through the cells just add spaces for the length of the cell and format the cell with strikethrough.

Alternatively make the cells really small and use the individual cells as pixels. I have seen this used to great effect.

 

[SkipVought]

Well, here's a way to put a line in a cell. However, it does not resize with a change in row height. Select a cell and run AddLine...

Sub AddLine()
    With ActiveCell
        Set oLine = ActiveSheet.Shapes.AddLine(.Left, .Top + .Height / 2, .Left + .Width, .Top + .Height / 2)
    End With
    Set oLine = Nothing
End Sub

Skip,

http://www.TheOfficeExperts.com

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