How to select row

aymanharake · #1 02-17-2017, 04:44 PM

I want to delete the row that the current selected cell is on. the following code deletes that cell, but how can i delete the entire row?

Code:

' cutRow Macro
'
' Keyboard Shortcut: Option+Cmd+u
'
     Selection.Delete
End Sub

jeffreybrown · #2 02-17-2017, 06:17 PM

Code:

Sub DeleteRow()
    ActiveCell.EntireRow.Delete
End Sub

aymanharake · #3 02-18-2017, 04:05 PM

Thank you

jeffreybrown · #4 02-18-2017, 04:09 PM

You are very welcome. Thanks for the feedback.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot Select Objects in Excel	instamatic	Excel	0	08-22-2016 10:45 AM
How to select different words at once	FTL	Word	5	03-08-2016 06:10 PM
select all tables	majed_m	Word VBA	5	07-30-2015 03:29 AM
Activate/ select ContentControl	czsti	Word VBA	1	08-14-2013 08:32 AM
Select text between characters	davers	Word	10	05-24-2009 05:15 AM