If a cell is blank the VBA code will return a value stored in cell C6. True and False Results: In this example if a cell is not blank the VBA code will return a value stored in cell C5. This example assumes that both the output and the associated test cell will be in the same row. Output and Test Range: Select the output rows and the rows that captures the cells that are to be tested by changing the x values (9 to 15).
Both of these values can be changed to whatever value you desire by directly changing them in the VBA code. If a cell is blank the VBA code will return a value of "No". True and False Results: In this example if a cell is not blank the VBA code will return a value of "Yes". You can also change the name of this object variable, by changing the name 'ws' in the VBA code. Worksheet Selection: Select the worksheet which captures the cells that you want to test if they are not blank and return a specific value by changing the Analysis worksheet name in the VBA code. Output Column: Select the output column by changing number 4, in ws.Cells(x, 4). Test Column: Select the column that captures the cells that are to be tested by changing number 3, in ws.Cells(x, 3).
Output and Test Range: Select the output rows and the rows that captures the cells that are to be tested by changing the x values (5 to 11).
0 kommentar(er)
