Need code for simple IF-Then
I'm trying to insert an "X" in any empty cells in Row 7 for columns C,D
E & F. I'm formatting all the cells in a large block (columns A - R,
with a varied number of rows), but the results using CurrentRegion
won't extend out past columns C - F when they are empty, which they
usually are. I could include a macro to insert the X's, but sometimes
these columns actually DO have data in them, and I don't want to
overwrite any data. THANKS
|