Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two columns (A and B) which return results from formulas in other cells.
I would like to have a macro read down the list of column A and if the result returned is empty/zero, the contents formula of its adjacent column B cell be deleted. I have complex code which doesnt work when the column B result returns a blank (which is the case when A is also blank), so this solution, although drastic will solve my problem adequately. Can anyone help? Thanks, Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to select data in non adjacent rows of a column automatically | Excel Discussion (Misc queries) | |||
automatically change column references in formulas | Excel Programming | |||
When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions |