This is good article to more utilize your excel formula with using INDEX MATCH, benefit of that are :
1. More flexible, if in vlookup you must put your reference in left side, with INDEX MATCH you can put reference in left or right site in your array reference.
2. Faster calculation, with spesific array you have set, INDEX MATCH calculation will be faster than VLOOK UP.
Why INDEX MATCH is Better...
Friday, October 17, 2014
Macro Tricks (Part 1)
For this time i will give you some tricks macro in Excel :
1. How to select second until last of row :
Dim Lastrow As Integer
Lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Range("A2:L" & Lastrow).Select
Lastrow is variable to identify what is number of cell with data.
after that we will select which row we need to be selected. if we want to select manually, we can select row with
Range("A2:L100").Select
it...
Subscribe to:
Posts (Atom)
Powered by Blogger.
