Code to delete entire rows if zero in a particular column (after pasting data in a new tab)

[AidanDanby]

Hi All,
Please can someone give me some code that will do the following:

1) Paste all data from Sheet1 into a new sheet.
2) Delete entire rows if there is a zero in column A

Cheers,

Aidan

 

[Peter_SSs]

Please report the full error message .....

You previously reported two different messages. Which one is it now?

Have you tried the post #3 code?

 

[vcoolio]

Hello Aidan,

With the high-lighted line of code, it appears that Sheet2 (which is a sheet code not sheet name) is incorrect. What is the name of your destination sheet or, better still, its sheet code? You can find the sheet code in the Project Explorer (to the left of the code field) with the sheet names in parentheses and the sheet codes directly before the sheet names.

Cheerio,
vcoolio.

 

[AidanDanby]

You previously reported two different messages. Which one is it now?

Have you tried the post #3 code?

I'm sorry Peter, I am getting myself in knots aren't I. That snippet was from Vcoolio's code.

 

[AidanDanby]

Hello Aidan,

With the high-lighted line of code, it appears that Sheet2 (which is a sheet code not sheet name) is incorrect. What is the name of your destination sheet or, better still, its sheet code? You can find the sheet code in the Project Explorer (to the left of the code field) with the sheet names in parentheses and the sheet codes directly before the sheet names.

Cheerio,
vcoolio.

 

[Peter_SSs]

That snippet was from Vcoolio's code.

Yes, I could see that from the image you posted but my (first) question was about the error message itself "Please report the full error message"

My second question was

Have you tried the post #3 code?

BTW, the codes should be in a standard module, not the sheet module. In the vba window use the menu to Insert -> Module and put the code there.
Having said that, I don't think that is the reason for your error on this occasion with vcoolio's code at least

 

[vcoolio]

So the sheet codes I've used are correct. Sheet1 is the source sheet and sheet2 is the destination sheet. On which row does your data start and which row is the headings row?

Cheerio,
vcoolio.

 

[AidanDanby]

So the sheet codes I've used are correct. Sheet1 is the source sheet and sheet2 is the destination sheet. On which row does your data start and which row is the headings row?

Cheerio,
vcoolio.

The first reference point in Sheet1 would be A2 (where the first zero sits).
The header row is the Row1.

 

[AidanDanby]

Yes, I could see that from the image you posted but my (first) question was about the error message itself "Please report the full error message"

My second question was


BTW, the codes should be in a standard module, not the sheet module. In the vba window use the menu to Insert -> Module and put the code there.
Having said that, I don't think that is the reason for your error on this occasion with vcoolio's code at least.

When I ran the Post #3 code I got the error mentioned in Post #6.

 

[vcoolio]

Hello Aidan,

Please use the XL2BB sample file uploader (refer to the top of any reply form) to upload a sample of your workbook. Your data set out, as per the image, appears problematic to both codes supplied and we'll need something to work and test with. We can't do so with the image. If your data is sensitive then please use dummy data.
You could also use a free file transfer site, such as WeTransfer, to upload a sample. If you use such a site, then please make sure to post the link to your file back here.

Cheerio,
vcoolio.

 

[AidanDanby]

Hello Aidan,

Please use the XL2BB sample file uploader (refer to the top of any reply form) to upload a sample of your workbook. Your data set out, as per the image, appears problematic to both codes supplied and we'll need something to work and test with. We can't do so with the image. If your data is sensitive then please use dummy data.
You could also use a free file transfer site, such as WeTransfer, to upload a sample. If you use such a site, then please make sure to post the link to your file back here.

Cheerio,
vcoolio.

Hi - I cannot download - it states 'This file type is not supported in Protected View'