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...
Type: Posts; User: littleiitin
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...
Try This:
Sub FindandDelete()
Dim rngMakeRange As Range
Dim lngCnt As Long
Dim rngFindNext As Range
Dim rngCheck As Range
Awesome --- :)
Try this
Sub FilterData()
Dim rngFilterRange As Range
Dim rngToCopy As Range
With Sheet1
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...
Thanks Excel Fox :)
The Extract Image function is already present in forum Under below thread..
...
Here is Solution how you can show Image in form' caption.
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...
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()
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 =...
Here is simplest Find All Method
Sub FindallM()
Dim rngFind As Range
Dim rngWhole As Range
Dim rngUnion As Range
Dim rngFirstFind As Range
Try This:
Sub rrr()
Nice Job Lalit.. Keep doing good work...
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...
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...
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
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
Congratatulations to everyone, being part of Excelfox Family:)
one word-- "Amazed"
Thanks Sri,
Received money..
Thanks
Rahul Kumar Singh
Please Replace This Code:
Sub SelectAllKeywords()
Dim objExcel As Object
Dim wbkExcel As Object
Dim wksAct As Object
Dim wksCheck As...
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...
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()
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
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...