In VBA programming Hungarian Notations don't make much sense because the data types of all variables is openly declared at the top of each procedure. There are other programming languages where this isn't possible. Nevertheless, a guy by the name of Leszynski and his partner Greg Reddick further refined the system. They called the prefixes 'Tags' and added suffixes called 'Qualifiers' to the 'Base Name' and their system became so widely used in Access that they fell out over how to continue its development and each started his own. A list of tags of the Leszynski naming convention is published by Wikipedia:
http://en.wikipedia.org/wiki/Leszynski_naming_convention
Indeed, the attraction of knowing which type of data a variable represents increases with the use of objects. Of these, most Excel programs have few. However, the system need not be applied universally. I apply it where I find it useful and dispense with it where I prefer short names. My For .. Next loops often count i rather than int. My row numbers are represented by R, not lngR, columns by C instead of lngC. But where I need names for, say, an array containing the values in a range of cells and for the range itself I will gladly resort to names like arrHolidays and rngHolidays.