Macro not Finding "blank" visible cells (when filtering

Hello there - This is my first post ever so I hope I am posting in the correct area.

I have a macro which I am attempting to code to validate if filtered data is blank. So far, after many searches on the internet I've not turned up any code that can assist with this. The filtered data is formatted as "General" (ex of data "28 NDC").

When filtering, if there is no data present, I want the macro to validate that the next visible cell is empty/blank. So far no attempts to use Count, CountA or anything have allowed me to succesfully traverse the visible cells, identify if cell is blank or not.

If the data is not present, then the macro should use GoTo FDC: (next filtered value "26 FDC") and run the same validations. I have 23 "values" that this routine will have to run on, data will change in size from week to week, and total row count can exceed 500,000 lines, so I think that anything relying on "integer" is not sufficient.

Here is my code:

Please Login or Register  to view this content.

...more code (looping above code starting at 'NDC' but changing filtered values for other locations

The cells are truly blank. Basically I have "audit" reports, that I have already imported into a template, sometimes though a report will not generate (for various reasons) so unless there is a way to have the macro tell what values it has each week (dynamically and completely independent on its own), then it seems to be that the easiest way is to just have it check all values in a procedural manner.

#Solved

Found the code i needed on

http://www.mrexcel.com/forum/excel-q...new-sheet.html

Please Login or Register  to view this content.