(C) 2009 - 2018 by Mourad Louha · All rights reserved

All posts tagged Columns

For some time now, I’m evaluating my web server log files with Excel 2010. Yes, there are many other good tools for analyzing logfiles on the market and I’m also using some of them. However, Excel 2010 provides the function to easily import and filter the raw data of my logfiles. Unfortunately, with such amount of data, I’m often „loosing“ the line while reading on the screen. Ok, I can surely increase the zoom factor of the sheet or setup borders for the cells; my wish was, however, to have a tool which highlights the current line or column. As Excel does not provide such a feature, I decided to implement my own tool in VBA. The following screenshot shows the tool in action:

VBA Highlighter

Read more