Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
do..loop
I would like to compare each cell in column B (which is month) with cell A1
(showing this month). If the text in cell A1 is same as column B, then keep the row. Otherwise, delete the row. I don't what's wrong with below coding!! Anyone can help me or any other good sugguestion? Thank you for your help. Range("B6").Select Do If ACTIVCECELL.Text = Range("A1").Text Then ActiveCell.Offset(1, 0).Select Else Selection.Delete Shift:=xlUp End If Loop Until ActiveCell.Text = "END" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DO LOOP in VBA | Excel Discussion (Misc queries) | |||
Do Loop | Excel Worksheet Functions | |||
Do Loop | Excel Worksheet Functions | |||
Do Loop | Excel Worksheet Functions | |||
Do Loop | Excel Worksheet Functions |