Printing Results to a text file

[chuckie2010]

Hi, I'm having a little trouble with this code below, the code works perfectly fine but stops when it finds an empty row. I intentionally include 1 blank row between groups of rows on the spreadsheet i'm working on. This cause's this code to stop after one group, i've tried telling the code to check the first empty row with the next row coming up to see if that row is empty also but my attempts failed & i'm not sure how to do it.
I have included the code below.

Can this code be made to only stop once it finds 2 empty rows and not just 1?

Below working code if no blank rows are present.

Please Login or Register  to view this content.

below code that i tried editing to check for 2 rows.

Please Login or Register  to view this content.

Thanks

[Leith Ross]

Hello chuckie2010,

If you have only one blank between the groups you could find the end of the range using something like this...

Please Login or Register  to view this content.

[chuckie2010]

Hi Leith, just tried that code in my spread sheet and it just produces an empty file. I've attached a copy of my excel sheet, and a copy of the exported results that my first lot of code created.

Hopefully you can help elimate the problem.

[Leith Ross]

Hello chuckie2010,

My typing is my weakness. I corrected the type in the macro. Here is the working code. This has been added to the attached worksheet.

Please Login or Register  to view this content.

[chuckie2010]

Hi Leith,
Your a star, thanks for fixing that code.
This evening i've been working on another macro for the same spreadsheet which is based on the same code. Would you mind performing your magic on this please.

Please Login or Register  to view this content.

Thanks Leith

James

[Leith Ross]

Hello James,

I can help you but I am not sure what is you want help with. Can you provide me with some more detail and a before and after example of the file layout?

[chuckie2010]

Hi Leith, I've been playing with this code again this evening and progressed a little further with my existing code and implementing your code a little further with the range feature.

The code below works on one ranged column but can this be upped to 3 ranged columns?
I've tried to include as many comments as possible in the code aswell.

Please Login or Register  to view this content.

From how i understand the code, it sets the range on column BA and looks at each row in that column for the letter 'm'

can i adjust the code to look at 3 coloumns and only if the row matches the 3 column criteria is exported to the file i'm creating.


Cheers

James

[Leith Ross]

Hello James,

Yes, the macro can be changed to export the row only if all three conditions are met. Can you explain this condition?

' column W to be empty, if anything is in the column the to leave it out.

[chuckie2010]

On my spreadsheet i have the words No Image if i haven't photographed the item yet.

If there are no words in the column w, on that particular row it can be included in the export, because description, image and everything else are correct. If no image exists then that cell will include the words "No Image" and the row cant be included in the export.

hope that makes sense.

ta

[Leith Ross]

Hello chuckie2010,

I changed the macro to check the three cells on each row before exporting the data. Here is the revised macro. This has been added to the attached workbook.

Please Login or Register  to view this content.

[chuckie2010]

Thanks its working how i would like it to.