View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Conditional Print Macro

I'm new to Macro's in Excel - but trainable

If cell xx has "AA" - I want to print range1 and range2
If cell xx has "BB" - I want to print range3 and range4
If cell xx has "CC" - I want to print range5 and range6

I would like to have a button that says "print" when the user is ready

How do I do this?

Thanks in advance for helping