I need the "go to" feature to find all the cells that are FALSE then delete
and move up all of the rows that have FALSE in the selected column. The
particular column I am addressing will either have a number or FALSE and
nothing else. Thanks.
--
David P.

Why not filter on FALSE and delete all the filtered rows?

"David P." wrote:

I need the "go to" feature to find all the cells that are FALSE then delete
and move up all of the rows that have FALSE in the selected column. The
particular column I am addressing will either have a number or FALSE and
nothing else. Thanks.
--
David P.

Use datafilterautofilter, filter on FALSE and delete the visible rows but
the top row (header row)


--
Regards,

Peo Sjoblom



"David P." wrote in message
...
I need the "go to" feature to find all the cells that are FALSE then delete
and move up all of the rows that have FALSE in the selected column. The
particular column I am addressing will either have a number or FALSE and
nothing else. Thanks.
--
David P.

ONe way:

Public Sub DeleteFalseRows()
Dim rDelete As Range
On Error Resume Next
Set rDelete = Columns("D").Cells.SpecialCells( _
xlCellTypeConstants, xlLogical)
On Error GoTo 0
If Not rDelete Is Nothing Then rDelete.EntireRow.Delete
End Sub

Change the column number to suit.

This assumes that FALSE is entered as a constant. If it's the result of
a formula, substitute xlCellTypeFormulas for xlCelllTypeConstants

In article ,
David P. wrote:

I need the "go to" feature to find all the cells that are FALSE then delete
and move up all of the rows that have FALSE in the selected column. The
particular column I am addressing will either have a number or FALSE and
nothing else. Thanks.