Search results for query: *

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...

Thank you WinblowsME. Your code worked like magic. It was just what I needed.

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...

Hi Skip, thank for your help on this. I tried it a few times and understand to a small degree what we are attempting to do, however i ran into tow errors. The first error was a "compile error" variable not defined. I addresed this by removing my Option Explicit statement at the very top of...

Can you help me out with the code, I am still quite new to VBA and my head is spinning right now from surfing the forums all day. Please help!!!!!

Skip, thank you for your suggestion. Are you sure their is no other way to do this? What if i can create a list of 30 specific words that i would like excel to search on and if a match is found then that match is highlighted in sheet2. How can i write this code: Below is my first attempt, but...

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...

Wow, it did not know their was a difference. Can I get the code for either of the two please. Thanks.

Hi, I tried it but for some reason it did not work. Can you tell me what to specify if i want the program to look in the first column (column A) and find all the cells with fonts that are red and then in column B, input the text "To Be Deleted". As an example, I have Kmart in the very first...

Hi, You need to use a SumProduct function. You do not need to use VBA code for this. I have done similar analysis using a SumProduct and it works. Try it out and let me know if this works for you.

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...