deletion of row

[VBABEGINER]

Hi,

Yesterday i got this following code of line, from one of yours experts.

Selection.EntireRow.Delete Shift:=xlUp

but i want this code activate below range a15. other wise if mistkly click on above cell of a15 then my designing row also delete.

Is there any method?

 

[VoG]

Try

If Selection.Row > 15 Then Selection.EntireRow.Delete

 

[VBABEGINER]

Try

If Selection.Row > 15 Then Selection.EntireRow.Delete

******************************************

Hey Sir,

Amazing..

 

[VBABEGINER]

ok....one more....can u give me chucky idea..
i used combobox...but ...
ok...list are displayed....but when i try to scroll down it does not scroll.
What i require....if scroll on the combobox list then that cursor ....u got it?
should go on down-down on items.

is it possible?

 

[VoG]

I don't understand. Try starting a new thread with a better explanation.

 

[VBABEGINER]

I don't understand. Try starting a new thread with a better explanation.

**********************
ok