Search results

Below is the script I using for sending auto email of the cell range C9:G27 in the attached Example File. >>> use code - tags <<< Sub SalesReportMail() Dim rng As Range Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail =...

Hi, I have some help in sending email using macro. Since i dont know anything about vba, just googled and using this macro to send mails by selecting any range. Sub Send_Selection() Dim Sendrng As Range On Error GoTo StopMacro With Application .ScreenUpdating = False .EnableEvents =...

@Luke.. thanks man.. but how about for different month gap. I mean, What if the rates varies for 4 & 8 months in 1st year and 5 & 7 months in 2nd year?

This is actually a mathematical question.. Sales 2014: Rs.36 Sales 2015: Rs.62 Here we can straightly say growth rate is 72%. But, in depth i need deviation of this 72% as how much due to increase in rate and how much due to increase in no. of units. I have attached the template. Thanks in...

Dear Narayan, Now i clearly understood that adding space after string will add space to the value of the string linked to it also. So while searching with or without space it matches the criteria. Thanks for your kind responses with humble patient in explaining my doubt.

Dear Narayan, I again telling you i already understood why we need to add the space in the string also. My question is how it works? How it ignores the space if the word is the last one. Because by adding space with string it will result as A1$" " &#62;&#62; A1space. How it working in the...

Dear narayan, Actually i understood the purpose of adding space to input string that to search in both the cases that the desired word in middle as well as ended at last. But my doubt is how adding of that space to the input string works in the above case? How it ignores the space if the...

Wow, i wonder why i didnt think to use "pen ". First of all thanks. This is my first question in this site and got answer in ten minutes. But i couldnt understand that in the SEARCH syntax you have given as A1&" " How it works?

I want to get a result as if A1 contains the word "pen", in B1 it should result as "pen" otherwise it should be "NO". So this is the formula i used in B1 =IF(ISNUMBER(SEARCH("pen",A1)),"pen","NO") Below are the results: Left side is input and right side is result 1) Black pen = pen 2)...

=Hi all =I have started using excel just before 2 years and i learned a lot myself while situations arised in my work. I found this site two days a back only I felt like did I have lived out of earth this much days. =I'm in beginner stage but i want to become awesome in excel and thats why...