Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If IsEmpty(Cells(x, 25).Value) Then Cells(x, 25).Value = "TRU"
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ruchie" wrote in message ups.com... Cells(x, 25).Value = Replace(Cells(x, 25).Value, "", "TRU") should this work to replace blanks as well? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and Replace Command | Excel Discussion (Misc queries) | |||
Replace menu command not working | Excel Discussion (Misc queries) | |||
where is the search/replace command located | Excel Worksheet Functions | |||
replace cut command | Excel Programming | |||
replace command | Excel Discussion (Misc queries) |