Conditional Formatting Issue after Pasting into

Hey,

So I have written this macro, and I have it doing what I would like it to overall, however, I have it copying from an If(ISBLANK(),"",J4) statement over to a sheet that has conditional formatting. The macro copies the "blank" values and paste specials the values over to the new sheet in the designated location where the conditional formatting is used to flag whether or not somethings been adjusted related to the data.

The issue I am having is, the values are being pasted as blank, but the formatting is being triggered as though it was not, and it is also sorting the blanks as though they were not, so I have empty rows coming up in the wrong color and in between the data that I would like grouped together.
It is also triggering the countA of the columns that I am using as a reference for where I would like it to paste based on the variables I dimed.

I realize that is has to do with the fact that I am technically pasting the "" part of the IF statement, I just don't know how to remedy it.

I have only been working with excel for a little less than a month, so if i am doing anything inefficiently in my macro, or posting this incorrectly for that matter, please let me know.

Please Login or Register  to view this content.

Hi,

As you pointed out - if a cell has a formula in it, excel no longer perceives it as blank, even if the result of the formula appears as such /""/

Assuming you are using cell that contain blanks conditional fromatting, I would change that to "use a formula to determine which cells to formet". The formula should be something like

Formula:

Please Login or Register  to view this content.

So, I just added a looping script to clearcontent on the range of cells that had the "" and ignore the ones that had data.
Thanks for the help.