Business Software

Recent Answers

2012-05-24 Excel - VBA Macro Change Value and Print:

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

2012-05-24 Using MS Access - MS Access- linking documents:

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

2012-05-24 Excel - Three veriable "if" type issue:

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

2012-05-23 Excel - Check format VBA:

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

2012-05-23 Excel - Removing duplicates between Excel docs:

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