Print with Macro

**zessie** · 07-08-2010, 02:30 PM

Hi,

Newbie at macro here..help!!

How do you do conditional printing of worksheets for macro (using recorded macro)?
Bacially I have to print for A-E(total of 5) under heading (cell D161).
Sometimes, I do not need to print for all 5 as there maybe only information for A-B and E,
no information for C and D.

Hence I should do a for or if/else loop to run?
What is e proper syntax?
Thanks.

Below is a sample of my recorded macro.

Please Login or Register  to view this content.

**Leith Ross** · 07-08-2010, 02:41 PM

Hello zessie,

Welcome to the Forum!

To make posts easier to read, copy and edit, please use code tags. I have done this for you because you are new. Do take some time to read the forum rules. These help make it easier to find and get answers quickly to your questions.

As a new member, please take some time to familiarize yourself with the rules.
Click here for the Forum Rules

**zessie** · 07-11-2010, 03:18 AM

thanks! anione who can help with the conditional printing code?

**royUK** · 07-11-2010, 03:25 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**royUK** · 07-11-2010, 04:00 AM

Have you bothered to read the Forum Rules?
Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

Cross posted at Code cage Forum

http://www.thecodecage.com/forumz/me...ual-basic.html