print a report based on cell value

**excelluni** · 05-25-2009, 03:40 PM

Hello there people,

I'm new on the forum and hope to learn some new excel tricks. When i was googling i found this post : http://www.excelforum.com/excel-prog...ell-value.html

I'm looking for the same thing, this great macro by Leith Ross looks for the word "buy" in kolom A starting at A2. Now this all works fine until i change the value of the colum into a if statement : =IF(C2>0;"buy";"NR"). See the attachment on what i mean.

If i run the macro now i get error 91 : objectvariable or blockvariable With is not set.

I can work around it, if i hardcode the A2 with "buy" and then A3 etc with the if statement i works for some strange reason. But there must be a smarter way of doing it, that's why i came here

.

Hope you guys can help me

. And i hope Leith Ross dont mind if use his code, it's super

.

Arjan

**royUK** · 05-26-2009, 12:36 PM

We are experiencing some problems since the srver move, Leith cannot post in this thread so he has asked me to post this amended code

Please Login or Register  to view this content.

**excelluni** · 05-27-2009, 07:57 AM

Hi there,

ooh no problem

but about the code, it's the same as in my test.xls. At least i couldnt find any difference. But thanks anyway.

After some extensive testing en googling i finaly found what i was looking for. I got my code working like how i want it to. This was just the basics i needed it to look for cells > 0 and then generate a report on those files. I've just combined serveral codes and used some of my own vba knowledge and put them together in one macro

.

I'll change this to solved, because i solved it in another way.

thanks