|re: The code below technically works fine, but the problem is, say for example in column 6 i gihtlight an entire row and delete it, i get a runtime error.|
Then the code doesn't "work fine".
re: "in column 6 i gihtlight an entire row and delete it"
How are you highlighting an entire row in a column?
Try this test:
Add this line as the first line of code:
MsgBox "The Target Address Is: " & Target.Address
Now delete a Row.
Note the Target.Address and think about what happens when the code tries to determine this value: