![]() ![]() Either by hitting ALT +F11 or selecting the Developer Tab | Code Group | Visual Basic. Preparing To Write The Macroįirst, we will need to open the Visual Basic Editor. Now we know the syntax and what is expected by Excel, let’s get some coding done. Header:=xlGuess– Choose this value if you want to excel to determine the existence of Header. Header:=xlNo – Choose this value if given Range doesn’t contain header Header:=xlYes– Choose this value if a given range does contain Header The user can specify three values in the header parameter. ![]() Header– determines whether the given range does contain a header or not. For e.g, if you gave the column position as 1,2,3 then it checks the duplicates only in column 1,2 and 3 by taking the first column in the selected range as the reference. Range – this is the given range specified by the userĬolumn– this defines the array of indexes of columns for checking the duplicate values.
0 Comments
Leave a Reply. |