Filter blanks and populate with a series

[Dwight Trumbower]

How does one filter on blanks and populate with a series?

I'm trying to replace all blanks in a column with TA1..TA2..TA3..etc. When
in filter mode, excel doesn't let you copy just to the filtered rows. I've
tried a few things from google, but I can't get anything to work.

Thanks

Dwight

 

[Tom Ogilvy]

It lets you copy just the filtered rows, but it sound like you want to paste
to just the filtered rows. As far as I know, you will have to loop through
all the rows (or use specialcells to loop through just the visible rows) and
update each cell as appropriate.