Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If then statement
Hi,
I have a piece of code that looks at an Excel spreadsheet, copies the cells data, and puts it in another Excel sheet. The first piece of data will always be there. But in some cases, subsequent fields may be blank. So I want to put in an If statement that says if subsequent values are blank, just fill them in with the first value. Here is what I have: testExpected = .Cells(currentRow, 6).Value ******* If .Cells.Value is Null then blah blah End If ******* Can someone help me with the code inside the asterisks please. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |