something isnt lining up with the paste. here is a picture of what happens, i
cant seem to get it aligned properly. here is my macro:
http://img119.imageshack.us/img119/8384/macromb4.jpg
also, the selection is the whole worksheet, so maybe that part of the code
needs modified? im not sure, im not so good with this macro business.
"Jarek Kujawa" wrote:
probably you didn't select an area with "total board" etc.
besides "Then" must be in the same line as "If" (the browser wrapped
it incorrectly)
try this version
Public Sub DeleteStuff()
For Each cell In Selection
If cell = ""total board" or cell = "total metal" or
IsNumeric(cell) or cell.HasFormula or IsError(Cell) Then
cell.Delete
End If
Next cell
End Sub
this macro will delete ONLY cells (fulfilling conditions) in the
SELECTED AREA