ok I have this ....
works great! and fast! but.. im just wondering how could this code be changed to do say "all" 17 columns?? in the same time.. Im doing this for blank spaces but for this example I call the blank space a * below.. so assume I want all the rows with *'s gone in a single instance..Code:LastRow1 = [A60000].End(xlUp).Row For i = 1 To LastRow1 If Cells(i, 1) = "" Then With Rows(i & ":" & i).EntireRow .ClearContents .FormatConditions.Delete End With End If Next i
eg
1|* |text|lala|1|26|text|lala|
1|26|text|lala|1|26|text|lala|
1|26|text| * |1|26|text|lala|
1|26|text|lala|1|26|text| * |
1|26|text|lala|1| * |text|lala|
right ?? so say I ONLY want completely filled rows and any incomplete dumped.
lemme know if this is possible.. or if I have to do 17 individual codes like above
changing all the i's to a b c d etc etc...
im thinking....
Code:LastRow10 = [A60000].End(xlUp).Row For i = 1 To LastRow1 If Cells(i, 1) = "" Then '--------------here?? needs like (i, 1 -17) ??? dunno how to code it tho. With Rows(i & ":" & i).EntireRow .ClearContents .FormatConditions.Delete End With End If Next i




Reply With Quote