find the blank cell in range and replace it

[ccs1981]

i am facing a problem here.
how to find the blank cells in range (J:K) until the end of row.
then replace it with "*"
please help and thanks.

[Paul]

Hi ccs,

This may work for you:

1. Select columns J:K
2. Press F5, then click 'Special', select 'Blanks' and click OK
3. With all of your blanks now selected, press Shift+8, which will insert an asterisk into the first blank cell.
4. Instead of pressing ENTER, press CTRL+ENTER. This will insert an asterisk into all of the blank cells you had selected in step 2.

[ccs1981]

sorry.. i want marco in programming, that 1 i also know

[Leith Ross]

Hello ccs1981,

Here is a VBA macro to fill the blanks with an asterisk. It is important to note that when using the SpecialCells method, it will fail if the last cell in the column is empty. If you run this macro on a empty column then nothing will happen. Cells that lie beyond the last cell with data will not be filled either.

Please Login or Register  to view this content.

Sincerely,
Leith Ross