Search:

Type: Posts; User: Sathish G; Keyword(s):

Search: Search took 0.00 seconds.

  1. How to get outlook mail data into excel macro

    Hi Guys,

    Hope you all going good!!!

    I need your help to get outlook email data into excel sheet.

    Following details to be collect:-

    1.From email address.
    2. Mail Subject.
  2. VBA Macro to paste the values with row and column alignment automatically.

    HI Everyone,

    I need a macro to align my results in same sheet according to last maximum used rows from multiple columns.

    I have given image link that how am expecting result that will give...
  3. VBA macro to paste in last row of A,B etc column by finding used row in multiple columns

    Hi,

    I need a macro code to paste the values as below of last used rows by finding in given 6 columns.
    For example:
    Here banana columns used more rows so based on more used i need your support...
  4. Re: Formula to calculate how many weekend days

    Hi you use this =SUM(INT((WEEKDAY(B1-{1,7})+B2-B1)/7))

    B1 and B3 is start date
    B2 and B4 end date

    example below:

    Start date 05-06-2019 =SUM(INT((WEEKDAY(B1-{1,7})+B2-B1)/7))
    end...
  5. Re: Run Time Error '91' : Object Variable or With Block not Set

    Thank you so much fluff its working great!!! thanks you your wonderful support
  6. Re: Run Time Error '91' : Object Variable or With Block not Set

    If r3Find is nothing, r3Find2 also nothing means then i need code to skip both to execute next.

    For example:

    If r3Find is nothing, r3Find2 also nothing

    Then it have to go next for r4Find...
  7. Re: Run Time Error '91' : Object Variable or With Block not Set

    Hi fluff if r3find is nothing how to resume next ? without error
  8. Run Time Error '91' : Object Variable or With Block not Set

    Am getting run time error on green marked line. Anyone please help to resolve this error.


    Sheets("Sheet2").Select
    Columns("A:A").Select
    lr = Sheets("Sheet2").Range("A" &...
  9. Re: Large file formula slow process & slow filter process

    Any one pls help???
  10. Re: Large file formula slow process & slow filter process

    These are the formulas am using for VLOOKUP

    Taking vlookup from sheet1 to Output sheet.
    Please somebody share the fastest way formulas.

    =VLOOKUP(A2,Output!B:B,1,0)
    =VLOOKUP(C2,Output!B:C,2,0)...
  11. Large file formula slow process & slow filter process

    Hi ,

    Am using the below vlookup formula but it taking very much time to apply and filtering the values.

    Is that any other of formula to make it faster than this.



    Range("C2").Select...
  12. Replies
    0
    Views
    157

    Run time error 7 out of memory

    Hi

    Please assist am getting Run time error 7 out of memory below red marked.

    .TextFilePlatform = 437 .TextFileStartRow = 1
    .TextFileParseType = xlDelimited
    ...
  13. Is that any other way to filter fast 60000 rows in a column

    Hi

    Some help Is that any other way to filter fast 60,000 rows by a column like wise i have 3 columns with 60,000 rows it taking too many time to calculate & process. Very slow to do the work
  14. Automatic leave tracker update send in mail

    Hi friends,


    Am not that much good in VBA so kindly help me.

    I need macro for below given employee leave tracker.

    Like any if one of the below employee run the macro from system then its...
  15. Re: How to get total filled column count in sheet1 to sheet2

    Thanks a lot! its working.
  16. Re: How to get total filled column count in sheet1 to sheet2

    I just want data contained total columns counts from sheet1 to sheet2
  17. How to get total filled column count in sheet1 to sheet2

    Hi,

    Some help me how to get total filled columns count from sheet1 to sheet2 excel formula
  18. Re: How to select multiple ranges between two same words in one column

    Great! working good thank you so much.
  19. Re: How to select multiple ranges between two same words in one column

    Hi friend given formula is not copy/pasting in sheet2
  20. Re: How to select multiple ranges between two same words in one column

    Yes only 4 selections wants to paste in sheet2
  21. Select multiple ranges between two same words in one column

    Sub SelectmultipleBetween()
    Sheets("sheet1").Select
    Dim findrow As Long, findrow2 As Long
    findrow = Range("B:B").Find("idle").Row
    findrow2 = Range("B:B").Find("proc", Range("B" &...
Results 1 to 21 of 23