Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro reads cells with numbers . If given number is found , delets
Column B with many cells . Every cell has a number . If given number is found
, the macro should delete entire row I want another macro which makes the opposite : if given number is found , keeps the row , but delets the rest |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro reads cells with numbers . If given number is found , delets
You want a clue or the answer?
Clue: Create a looping macro which iterates over each cell from the last to the first, checks the value of the cell and deletes the entire row if appropriate. Use integer variables to track which row to delete. "andrei" wrote: Column B with many cells . Every cell has a number . If given number is found , the macro should delete entire row I want another macro which makes the opposite : if given number is found , keeps the row , but delets the rest |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro reads cells with numbers . If given number is found , de
Actually i want the answer . My Knowledge in VB is very low
"Dan" wrote: You want a clue or the answer? Clue: Create a looping macro which iterates over each cell from the last to the first, checks the value of the cell and deletes the entire row if appropriate. Use integer variables to track which row to delete. "andrei" wrote: Column B with many cells . Every cell has a number . If given number is found , the macro should delete entire row I want another macro which makes the opposite : if given number is found , keeps the row , but delets the rest |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need macro that analyses 2 columns . Delets row if same text is fo | Excel Programming | |||
Macro analyses Cell . If text found , delets entire row | Excel Programming | |||
Macro - reads cells in a column .If keyword found moves cell conte | Excel Programming | |||
Macro that delets all cells containg ALL words in bold | Excel Programming | |||
Macro which searches for a character . When found delets what's be | Excel Programming |