Greetings,

I have a big report that contains a column that I want to link to in a macro. I want it to perform one function if the cell contains ANY text, and do nothing if it is blank.

The problem I have is the way the report is generated I can't seem to find any way to make them differentiate. The cells that appear blank actually have a single space in them. They are all formatted as "General" - although I could change that if need be.

I have tried "replacing all" and removing the spaces, but that doesn't seem to work.

For now I have the processes that follow down, and they are working, the problem is that it either does it for all or none, and no matter what I try I can't get it to differentiate between the cells that have data, and the "blank" cells that have a space.

Does anyone have a suggestion? I've spent the best part of a day trying different combinations of things and can't seem to nail it.

-S