Select and delete entire row Excel VBA macro

  • Thread starter Thread starter RL
  • Start date Start date
R

RL

Hi,
I cannot find out how to select and delete the entire row - row number
varies but contains the active cell. Anyone who can help?
 
Blush - tried that with a spelling error
Thanks

Don Guillett said:
activecell.EntireRow.delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically select entire rows on pressing down and up-arrow key 2
Word VBA for deleting Selected Row 0
Would love to write macro to delete any row that DOESN'T containspecific text.. 6
Macro analyses Cell . If text found , delets entire row 6
Combine 2 columns in a dynamic range into one 7
Macro: search word, select row, copy. 3
Fails to delete empty rows 4
Deleting rows 6

Back
Top