Search:

Type: Posts; User: littleiitin

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Convert All Vlookup formulas to Index-Match in a worksheet

    Hi Everyone,

    I have seen many requests at work to convert Vlookup formulas into Index match.

    Wrote a code which will convert all vlookup formula of a worksheet into Index match formula on a...
  2. Replies
    7
    Views
    3,150

    Try This: Sub FindandDelete() ...

    Try This:



    Sub FindandDelete()

    Dim rngMakeRange As Range
    Dim lngCnt As Long
    Dim rngFindNext As Range
    Dim rngCheck As Range
  3. Awesome --- :)

    Awesome --- :)
  4. Replies
    7
    Views
    3,150

    Try this Sub FilterData() Dim...

    Try this




    Sub FilterData()

    Dim rngFilterRange As Range
    Dim rngToCopy As Range
    With Sheet1
  5. Replies
    0
    Views
    1,493

    Finding Selected Criteria in AutoFilter

    Hi,

    Some time in codes we want to check what all options we have passed in autofilter.

    Below is the Code to Get the Selected Options.

    You can just change your Filter Range to get the desired...
  6. Replies
    3
    Views
    6,659

    Thanks Excel Fox :) The Extract Image function...

    Thanks Excel Fox :)

    The Extract Image function is already present in forum Under below thread..
    ...
  7. Replies
    3
    Views
    6,659

    Inserting Image In VBA User Form Caption

    Here is Solution how you can show Image in form' caption.
  8. Change Below lines in Red section accordingly...

    Change Below lines in Red section accordingly -------------------------



    strCSV_1_Columns = "A:C,E,G,I" ' Let Say Column A to C and Columns E, G, and I
    strCSV_2_Columns = "D,F,H,J:L" ' Let Say...
  9. Hi Please Paste both codes and Change Red Items...

    Hi Please Paste both codes and Change Red Items according to Your Need activate the Sheet where data is and run the code------------





    Option Explicit

    Sub SaveExcelasCSV()
  10. Replies
    2
    Views
    1,513

    Below is the code for saving workbook as csv for...

    Below is the code for saving workbook as csv for Multiple saving you can use loop



    Sub SaveasCSV()
    Dim strPath As String
    Dim strFileName As String

    strPath =...
  11. Here is simplest Find All Method Sub...

    Here is simplest Find All Method



    Sub FindallM()

    Dim rngFind As Range
    Dim rngWhole As Range
    Dim rngUnion As Range
    Dim rngFirstFind As Range
  12. Try This: Sub rrr()

    Try This:




    Sub rrr()
  13. Replies
    7
    Views
    5,959

    Nice Job Lalit.. Keep doing good work...

    Nice Job Lalit.. Keep doing good work...
  14. Replies
    8
    Views
    14,575

    The below is compatible with all access database...

    The below is compatible with all access database (above code will not work for 2010 database) .The only requirement is add refrence for Microsoft Access:

    This code can also make backup before...
  15. Replies
    1
    Views
    897

    1: Select your data 2: Copy the selected range...

    1: Select your data
    2: Copy the selected range
    3: Click anywhere out side selected range
    4: Right Click -> Paste Special -> Values also Check "Transpose" option
    5: Click OK


    HTH...
  16. Hi SP69, if you have chart name only and you...

    Hi SP69,

    if you have chart name only and you want to get the worksheet name then only way is to navigate through all the sheets which you already did.

    Thanks
  17. What I understand, you want only last one...

    What I understand, you want only last one thousand rows in your main sheet and complete data in Data1 sheet.

    Am I Correct?

    Thanks
    Rahul
  18. Replies
    5
    Views
    19,940

    Congratatulations to everyone, being part of...

    Congratatulations to everyone, being part of Excelfox Family:)
  19. one word-- "Amazed"

    one word-- "Amazed"
  20. Thanks Sri, Received money.. Thanks ...

    Thanks Sri,

    Received money..


    Thanks
    Rahul Kumar Singh
  21. Please Replace This Code: Sub...

    Please Replace This Code:



    Sub SelectAllKeywords()

    Dim objExcel As Object
    Dim wbkExcel As Object
    Dim wksAct As Object
    Dim wksCheck As...
  22. Sri Save File as Macro enabled file.. Its...

    Sri Save File as Macro enabled file.. Its Extension is .docm and docx

    In previous file I have provided solution to highlight only complete word and not part of the word.

    Please Use Below Code...
  23. Sri Please find The code for Moving from One...

    Sri Please find The code for Moving from One Keyword to other: I have assigned a Hot Key Crtl+6

    Just Add a module and place this code:






    Sub CheckMove()
  24. Please don't delete the listboxes... You will...

    Please don't delete the listboxes...

    You will not be able to see because I am making their size small but they are used in code so keep them as it is.


    Thanks
    Rahul Kumar Singh
  25. Sri, Please find the attached file. With All...

    Sri,

    Please find the attached file. With All your Requirements...

    Please Drag n drop all the modules and forms and also copy the code from thisdocument to your files thisdocument.

    I have...
Results 1 to 25 of 90
Page 1 of 4 1 2 3 4