15th January 2013, 05:07 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 589
|
|
Quote:
|
Originally Posted by stugots
benton, it may make things easier allround to delete out all the place records prior to using bf's data
The code below does the job, let me know if you need instructions on use
Code:
Sub delete_place_records()
Dim lst As Long
Dim i As Long
lst = Range("E" & Rows.Count).End(xlUp).Row
For i = lst To 1 Step -1
If Range("E" & i).Value Like "TO BE PLACED" Then
Range("E" & i).EntireRow.Delete
End If
Next i
End Sub
|
stugots
Thanks again.
I have absolutely no idea where and how to put the code in. But I would like to. My New Years resolution "Learn Excel"
I am bringing a 2000 Glenowen Shiraz down to table To have a drink for you. Organic from 100yr old rootstock.
beton |