You are here:
Yan, this macro should do what you want if you have your print area defined to the section want printed (otherwise it will print the whole used range of the worksheet) Sub ABCPrint() Dim sh As Worksheet
Your only problem is the requirement for the document to appear on the form. Embedding viewers into the form, can get complicated. All you need is a hyperlink field that stores the location of the
The formula =AND(E2="ray",A33="George",E33>2) will result in a TRUE if and only if E2 equals "ray" and A33 equals "George" and E33 is greater than 2. The formula will result in a FALSE if any one or any
devin, turn on the macro recorder. select a cell Change one of its format attributes. Turn off the recorder. Look at the recorded code (it will show you many of the attributes even though
Jessica if each list is a single column, then in an adjacent column you can put in a countif formul say A2 has the first entry for list2 and the names in list1 are on a sheet named List1 (in the

©2012 About.com, a part of The New York Times Company. All rights reserved.