Macro to Run Based on Cell Value

[mrmoc85]

I currently have a macro that checks to see if a number range is found in a data file and if one is it will input a yes into an adjacent column.

Please Login or Register  to view this content.

After this macro tells me which rows contain the numerical values I need it to then do validation checks to look for gaps in information. My goal would be to have it run only on cells that have the "Yes" in the specific column and for those rows target specific cells to see if they are blank or a certain character length. However, I do not know how to specify for Excel to only check certain rows for these data gaps based on a cell value, as I would know only how to do it for a range which would look at unnecessary rows. Below is a general idea of the format I would want, but I do not know how to have it only run for the specific rows.

Please Login or Register  to view this content.

I appreciate any help.

[HaHoBe]

Hi, mrmoc85,

maybe use the Autofilter and SpecialCells(xlCellTypeVisible) for that (and maybe add a check for the last line to be greater or equal if the first row is showing the headers):

Please Login or Register  to view this content.

Ciao,
Holger