Hello,
I have a range with formulas from C1:C100, I'd like to select just the rows that contain visible values, if the formula result is blank doesn't select it, I don't want to perform the autofilter manually so I'd prefer a VBA macro, my intention is to create a txt file to loads it to other program, if the txt file has blank rows the loading process fails.
Can someone help me?
I have a range with formulas from C1:C100, I'd like to select just the rows that contain visible values, if the formula result is blank doesn't select it, I don't want to perform the autofilter manually so I'd prefer a VBA macro, my intention is to create a txt file to loads it to other program, if the txt file has blank rows the loading process fails.
Can someone help me?