Deleting Row

  • Thread starter Thread starter gregork
  • Start date Start date
G

gregork

I'm still grappling with a code for deleting an entire row from a sheet. I'm
getting nowhere so I was hoping someone could start me on the right track
with a sample code here's the details:

On Sheet 1, Cell A1 is a 5 Digit number I want to lookup on Sheet 2, Range
A2:A1000 and then delete the entire row corresponding to the number.

Cheers
gregorK
 
On Sheet 1, Cell A1 is a 5 Digit number I want to lookup on Sheet 2
Range
A2:A1000 and then delete the entire row corresponding to the number.


RowToDelete = Sheets("Sheet1").Cells(1, "A")

Sheets("Sheet2").Cells(RowToDelete, 1).EntireRow.Delet
 
You must log in or register to reply here.

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

i = row number of last occurance of duplicate string Column A 4
Code for deleting entire row 2
Delete rows based on contents of Col A 0
Another code for deleting row 3
delete row 2
Delete Entire row if value don’t match 3
Run two macros for two different sheets 11
clear all sheets code 4

Back
Top