Hi All,
I the attached which is helping to filter top 5,10,15 numbers of PivotTable11 in sheet2.
now i would like to filter both PivotTable11 and PivotTable2 in the Sheet2.
Is this...
Type: Posts; User: Prabhu
Hi All,
I the attached which is helping to filter top 5,10,15 numbers of PivotTable11 in sheet2.
now i would like to filter both PivotTable11 and PivotTable2 in the Sheet2.
Is this...
Hi All,
I am using the below code to copy range from excel to Outlook Mail body. Now i want to past the copied range from excel to outlook as image instead of value.
Kindly help to modify the...
Hi,
could anyone help me why the attached excel vba is not working.
Yes,
with the same format of Sheet 1 along with the formulas in cell( instead of value format) like "=149/6" will solve the purpose.
also the row and column are flexible number of row used to...
request your help to resolve the error.
Hi Admin,
Still i am getting same error
Thanks!
I could not run the macro,below code shows as run time error '1004' Application-defined or object -defined error.
Dest.Resize(UBound(d, 1), UBound(d, 2)).Value2 = d
Hi All,
I have a complex query.
In the excel sheet column A values to be divided with rest of the columns.
Example Cell A1 value to be used to dived rest of the visible rows like B1, C1...
Hi,
I want to select the the cells and it's row(only visible) if the cell contains "Total", "Grand Total","Section" in the column "A"
Kindly help if this can be done thru VBA.
Regards,
...
Hi,
The below code is help to select the column B equals to the used range of column A
Range("B2:B" & Cells(Rows.Count, "a").End(xlUp).Row).Select
Similarly i would required to modify the...
Hi Friends,
i would like to round the numbers in the range of cells and its rows(right side) for given below.
range:"B8:B18", "B21:B21", "B24" and its used row
Workbook attached for your...
Do i need to do any changes in the region and language settings?
my current setting format is English India & Short date format is dd-MM-yyyy.
I found 2 issues:
1.It is taking MM/DD/YYYY instead of DD/MM/YYYY.
2. If the input dates between 1- 10 example 08/10/2014(10th Aug 2014) it is deleting correctly but the input dates between...
No Sir,
It is not deleting.
Thanks it is working!
But it is taking huge amount of time when we delete larger data. i think it is deleting row by row.
can we make change to delete the enter in one short now like deleting...
Hi,
I tried, but it is not deleting the record after the given date. i.e it is struck on the filter.
Sub MYFILTER()
Dim W1Startdate As Date
W1Startdate = InputBox("Please Enter the Start...
Hi Frineds,
My macro is not working, i need to apply filter thur message box and delete after the given date rows.I have attached the macro sheet for your reference .
Kindly help to correct the...
Hi All,
I am using the attached macro to send excel sheet thru outlook mail body and am facing problem when the sheet is not exist.
In the attached macro "Sheet 9" send to...
Thank you so much!!
Hi Alansidman,
I am sorry, i tried but could not bring the text to the new line.
Thank you so much!
It is working good.
i have a one more small correction.
Even after inserting the code "vbCrLf" all are printing in the first line i.e. Name and the message (Pls find the...
Hi Friends,
I have attached macro which will help me to send work sheet thru outlook mail.
In this macro i am using "HI" in front of Persons Name.
can we use Good morning,Good afternoon or...
Hi Friends,
I have attached a workbook with 2 macro program.
Macro 1.Attachment: this macro help me to attach more than one sheets as single work book to send to particular email id given in...
Hi Admin,
As advised, i have completed the step one i.e attaching the sheet in to mail. now i need to paste the summery sheet in to the mail.
Example If i attach Sheet "IJKL" in the mail,...
Hi All,
I Required a macro to attach Sheet 1 from my workbook to outlook mail and sheet2 in to the body of the same mail and send to specified mail id.
kindly help to get VBA code for the same....