Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How create blank cell value as the result of Excel "IF" function?
How can I best create blank cell value as the result of the Excel "IF"
sorksheet function? That would be useful "Paste Special" a column or row of the results over an existing column of entries, while skipping blanks, to over-write only the cells for which the results are non-blank. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How create blank cell value as the result of Excel "IF" function?
Let's say we have data from A1 thru A100, but there are some blanks in it.
We want to copy column A to column B, but not the blanks in column A. So if A10 is blank, don't copy it over. Sub copy_no_blanks() For i = 1 To 100 If Cells(i, "A") = "" Then Else Cells(i, "A").Copy Cells(i, "B") End If Next End Sub -- Gary''s Student gsnu200710 "Pocket Protector as a Fashion Statement" wrote: How can I best create blank cell value as the result of the Excel "IF" sorksheet function? That would be useful "Paste Special" a column or row of the results over an existing column of entries, while skipping blanks, to over-write only the cells for which the results are non-blank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If result of formula is "" (Blank) why is this considered a num. | Excel Worksheet Functions | |||
Why MS Excel produce diffrent result for the function "Quartile" | Excel Worksheet Functions | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
How do I replace a "#N/A" formula result with a blank in excel? | Excel Discussion (Misc queries) | |||
How to "blank" pivot table calculated fields if result = 0 | Excel Worksheet Functions |