VBA to delete a row containing a value equal to the value corresponding to the highlighted cell

[prasadyanz]

Few rows of the tables will be already highlighted, i want to delete the rows with value(at column A) equal to the value of column a of the highlighted ones

for example

1.50	270.00	90.00	17.00	6.01	-0.17	5.63
1.50	270.00	180.00	17.00	6.06	-0.13	6.67
1.50	270.00	270.00	17.00	6.02	-0.17	5.62
1.00	0.00	0.00	17.00	5.60	-0.18	6.00
1.00	0.00	90.00	17.00	5.65	-0.13	6.54
1.00	0.00	180.00	17.00	5.71	-0.09	8.14

<tbody>
</tbody>

in the above table, 5.63 and 5.62 are highlighted(whose corresponding value at column A is 1.5), i want delete all the rows which has 1.5 at column A.

Its a bit complex for me, please let me know how to proceed. thanks.