Macro for deleting the rows those having empty cells in either of the columns or both

[drniranjan]

Question:

1 3
blank 8
3 7
5 11.5
1 4
blank 10
blank blank
23 12
9 blank

Ans should be:
1 3
3 7
5 11.5
1 4
23 12

thnking you in advance.........N.

 

[VoG]

Try

Sub test()
Columns("A:B").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

 

[drniranjan]

hi,
thanks for the code. Working excellent....however, my final requirement is to estimate the fitting coefficients to the data sets using power function.

For instance, after deteting the empty cells........

I have the data sets:

A B C D E F so on...
1 1 3 4 4 5
2 4 1 2 4 1
2 8 2 7 2 9
1 6 2 9 3 9

I need the R square and the fitting power equations for consequtive data pairs...means, between A &B; C &D; E and F; .....so on.........


regards, N

 

[VoG]

Take a look at the LINEST function.