Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wom2007
  • Content: Threads
  • Order by date
  1. wom2007

    Email Code Modification Help

    Hi, the code below emails a workbook to any email address specified. I would like your help in modifying it so that I can send five separate tabs in the same workbook to five different email address. Thanks for your help. Sub Email() 'Input box to verify password Dim myPassword As String...
  2. wom2007

    Help On Printing Code

    Hi, I am trying to create a code that will allow me print all the sheets in several workbooks that is located in a similar directory folder. I started out with the following code, but I cannot get it to work. Sub TempPrintMultWkbk() Dim PathNm As String PathNm = ActiveWorkbook.Path Dim FSO...
  3. wom2007

    VBA to Search, Identify and Highlight Duplicates

    Thanks to all who responded to my last question. Here is a challenge. I have some account data I pull at work: I am trying to create a VBA code that does the following in a workbook: Look in Sheet1, column A, each row, Then look in Sheet2, column A, each row, And search to see if any of the...
  4. wom2007

    VBA If statements help

    Hi, I am trying to write a VBA code in excel that gives me a response in the correspnding row based upon whether or not the condition i specified is met. Example: I want to tell Excel to go to Column A, search all the cells, and If the cell has a font that is red, go to column B and put the...

Part and Inventory Search

Back
Top