Using Findformat

[stuartgb100]

Hi,

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

Please Login or Register  to view this content.

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

Thanks,
Stuart.

[Richard Buttrey]

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]

Richard,

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

Cheers.

[Arkadi]

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]

Thanks Arkadi,

With luck, the workbook is attached.

Regards.

[Arkadi]

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?

[stuartgb100]

Sorry - wrong workbook

Here is the correct wb.

Can I delete the original wb ?