Using Findformat

**stuartgb100** · 05-04-2015, 01:02 PM

Hi,

This (given) code finds a cell with its top border set,
but doesn't if it holds a value:

With Application.FindFormat
    .Clear
    .Borders(xlEdgeTop).LineStyle = xlContinuous
    .Borders(xlEdgeTop).Weight = xlThin
    .Borders(xlEdgeTop).ColorIndex = xlAutomatic
End With

I've tried removing ".Clear" but it makes no difference.

Thanks,
Stuart.

**Richard Buttrey** · 05-04-2015, 01:16 PM

Hi,

Would you upload the workbook so that we can see the request in context and explain what you expect to happen and when.

**stuartgb100** · 05-04-2015, 01:20 PM

Richard,

Sorry to be dumb, but how to upload the workbook, please?

Cheers.

**Arkadi** · 05-04-2015, 02:18 PM

If you type a reply and click "Go Advanced" in the bottom right, you will have more options... one is a paperclip that will let you attach.

**stuartgb100** · 05-04-2015, 02:54 PM

Thanks Arkadi,

With luck, the workbook is attached.

Regards.

**Arkadi** · 05-04-2015, 03:07 PM

There is no code in this... findformat sets parameters about what to find... in itself it doesn't search, so without more code I'm not sure what you need done here?