LinkBack URL
About LinkBacks
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.
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.
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.
sorry.. i want marco in programming, that 1 i also know
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.
Sincerely,
Please Login or Register to view this content.
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks