Macro to Clear All from Non Visible Cells

[teynon]

I am looking for a macro that will do a clear all on all Non Visible Cells in a worksheet.

Thank you,

Tim

[Leith Ross]

Hello Tim,

Welcome to the Forum!

What do you mean by "non visible"? Cells that are hidden or cells that are part of a filtered list like you see with AutoFilter?

Sincerely,
Leith Ross

[teynon]

I am using a VBScript to pull data from two columns (A and B) in excel. This data is either copied and pasted or type into the two columns. Unfortunately if there is any non visible data characters in any of the cells it will throw a type mismatch 13 error. The only way I can get it to work is if I highlight cells that do not have visible data in them and do a clear all. I was hoping for some type of macro that would do a clear all on all cells that were not visible.

[Leith Ross]

Hello teynon,

If you post your code, I see what the is causing the error.

Sincerely,
Leith Ross

[royUK]

Maybe using the Clean Function