Search:

Type: Posts; User: Prabhu

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    566

    Top N Value using Slicer

    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...
  2. Excel vba paste range into email body as picture

    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...
  3. Thread: VBA Code Error

    by Prabhu
    Replies
    1
    Views
    875

    VBA Code Error

    Hi,

    could anyone help me why the attached excel vba is not working.
  4. Yes, with the same format of Sheet 1 along...

    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...
  5. request your help to resolve the error.

    request your help to resolve the error.
  6. Hi Admin, Still i am getting same error

    Hi Admin,

    Still i am getting same error
  7. Thanks! I could not run the macro,below code...

    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
  8. Divide Rest of the Columns using Column A values

    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...
  9. Replies
    1
    Views
    1,889

    Conditional Selection of cells and its row

    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,
    ...
  10. Replies
    2
    Views
    778

    Select till row destination

    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...
  11. Replies
    1
    Views
    919

    Round the custom range of row

    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...
  12. Replies
    11
    Views
    2,438

    Do i need to do any changes in the region and...

    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.
  13. Replies
    11
    Views
    2,438

    I found 2 issues: 1.It is taking MM/DD/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...
  14. Replies
    11
    Views
    2,438

    No Sir, It is not deleting.

    No Sir,

    It is not deleting.
  15. Replies
    11
    Views
    2,438

    Thanks it is working! But it is taking huge...

    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...
  16. Replies
    11
    Views
    2,438

    Hi, I tried, but it is not deleting the record...

    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...
  17. Replies
    11
    Views
    2,438

    Apply filter and delete rows thru Messege Box

    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...
  18. Replies
    1
    Views
    905

    Modification in the Excel to Outlook mail

    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...
  19. Replies
    6
    Views
    1,478

    Thank you so much!!

    Thank you so much!!
  20. Replies
    6
    Views
    1,478

    Hi Alansidman, I am sorry, i tried but could...

    Hi Alansidman,

    I am sorry, i tried but could not bring the text to the new line.
  21. Replies
    6
    Views
    1,478

    Thank you so much! It is working good. i...

    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...
  22. Replies
    6
    Views
    1,478

    Insert salutation

    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...
  23. Send Mail From Excel Via Outlook With Attachment And Range As Mail Body

    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...
  24. Hi Admin, As advised, i have completed the...

    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,...
  25. Attaching and pasting excel sheet in to a new 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....
Results 1 to 25 of 55
Page 1 of 3 1 2 3