Excel Macro/VBA Codes and Useful Functions

Macro/VBA Codes

urShadow's Blog: Macro for importing and formatting a text file http://naumankhan.blogspot.com/2012/10/macro-for-im… View Now

urShadow's Blog: VBA/Word Macro to Write R if it find Red Color and G if it finds Green color highlighted http://naumankhan.blogspot.com/2011/05/vbaword-macr… View Now urShadow's Blog: VBA/Macro For Excel 2010 to process 4 csv files and generate a graphical report (version 2) http://naumankhan.blogspot.com/2011/01/vbamacro-for… View Now urShadow's Blog: VBA/Macro For Excel 2010 to process 4 csv files and generate a graphical report http://naumankhan.blogspot.com/2010/12/vbamacro-for… View Now urShadow's Blog: VBA/Macro Code for Excel 2010 to combine two files based on certain criteria and perform some post processing http://naumankhan.blogspot.com/2010/09/vbamacro-cod… View Now urShadow's Blog: Dynamic file reading Excel 2007 VBA/Macro http://naumankhan.blogspot.com/2010/03/dynamic-file… View Now urShadow's Blog: VBA/Macro Code for Excel 2007 to calculate specific values based on various criteria http://naumankhan.blogspot.com/2010/02/vbamacro-cod… View Now urShadow's Blog: Copying data from multiple excel files to one excel file through Macro / VBA http://naumankhan.blogspot.com/2010/01/copying-data… View Now Useful Excel Functions urShadow's Blog: How to use Excel's VLOOKUP Function http://naumankhan.blogspot.com/2014/09/how-to-use-e… View Now urShadow's Blog: Insert the current date and time in a cell - Excel http://naumankhan.blogspot.com/2014/06/insert-curre… View Now urShadow's Blog: Excel 2013: Groups and Subtotals - GCF Global Learning http://naumankhan.blogspot.com/2014/05/excel-2013-g… View Now urShadow's Blog: How to find 3rd highest value in a range in Excel http://naumankhan.blogspot.com/2010/01/how-to-find-… View Now urShadow's Blog: In Excel how to search a text string + get TRUE/FALSE result http://naumankhan.blogspot.com/2014/03/in-excel-how… View Now urShadow's Blog: How to change background color based on cell value in Excel? http://naumankhan.blogspot.com/2014/01/how-to-chang… View Now urShadow's Blog: How to keep one variable constant with other one changing with row in excel http://naumankhan.blogspot.com/2014/01/how-to-keep-… View Now   urShadow's Blog: How to auto fill Excel cells by week ranges? http://naumankhan.blogspot.com/2013/12/how-to-auto-… View Now urShadow's Blog: Excel 2007 Demo - Explore Adventure Works in Excel by using an OLAP PivotTable report http://naumankhan.blogspot.com/2010/12/excel-2007-d… View Now Miscellaneous urShadow's Blog: To open two Excel windows at once on two Monitors http://naumankhan.blogspot.com/2010/12/to-open-two-… View Now urShadow's Blog: First Look Microsoft Office 2010, by Katherine Murray http://naumankhan.blogspot.com/2010/01/first-look-m… View Now urShadow's Blog: Learning Resources http://naumankhan.blogspot.com/2010/03/learning-res… View Now

 

-urShadow