Extract cells with no border

[banyard2000]

Hello,

I have a sheet into which a macro inputs new data on a weekly basis. The data comes from a number of other sheets.

As the document which it inputs to is a live document, to identify the new content each week it inputs without borders so I can clearly identify newly added content.

I need to extract the newly added content (content with no border applied once added to the new sheet) to another excel sheet. How can I filter by cells that have no border?

Thanks in advance,

Bradley

[MarvinP]

HI,
Look at http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

I'd be looking for a different method to find differences. To find borders is much harder than it might seem.

How about putting a background color in your new data before moving it to the old sheet? Will the cell background color be transfered? Would this be better to find new stuff?