A simple macro to delete 1 row at a time when the value of a cell
changes now deletes 250+ rows at a time. I only want to delete the 1st
row of a worksheet when there is a change in a cell on the 1st row, then
move the following row in its place.
Private Sub Worksheet_Change(ByVal Target As Range)
Range("1:1").Select
Selection.Delete xlShiftUp
End Sub
Thanks for any help!!
--
stumanchu
------------------------------------------------------------------------
stumanchu's Profile:
http://www.excelforum.com/member.php...o&userid=33793
View this thread:
http://www.excelforum.com/showthread...hreadid=535662