Hello happy people,

I've done a macro, that opens a huge text file in excel (as i have
some figures to extract from it).
I can select a text file, it opens it, it converts it to columns, it
automatically finds a keyword and selects the word..

What should i use to delete all the rows above the selected cell?

Thank you!


--
drucey
------------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553
View this thread: http://www.excelforum.com/showthread...hreadid=534466

After a cell has been selected:

Sub gnsu ()
Dim L As Long
L = Selection.Row - 1
If L 0 Then
s = "1:" & L
Rows(s).Select
Selection.Delete Shift:=xlUp
End If
End Sub

will delete all the rows above it.
--
Gary''s Student


"drucey" wrote:


Hello happy people,

I've done a macro, that opens a huge text file in excel (as i have
some figures to extract from it).
I can select a text file, it opens it, it converts it to columns, it
automatically finds a keyword and selects the word..

What should i use to delete all the rows above the selected cell?

Thank you!


--
drucey
------------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553
View this thread: http://www.excelforum.com/showthread...hreadid=534466

Garys Student, thank you so much. You are the best person i know today.


--
drucey
------------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553
View this thread: http://www.excelforum.com/showthread...hreadid=534466

You are very welcome
--
Gary's Student


"drucey" wrote:


Garys Student, thank you so much. You are the best person i know today.


--
drucey
------------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553
View this thread: http://www.excelforum.com/showthread...hreadid=534466