A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Sub CopyandPasteValues() Application.ScreenUpdating = False Sheets("Unique List").Columns(2).ClearContents Sheets("Data").Range("DR:DR").SpecialCells(xlCellTypeConstants).Copy Sheets("Unique List").Range("B1").PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False Sheets("Unique List").Range("B:B").RemoveDuplicates Columns:=2, Header:=xlYes Application.ScreenUpdating = True End Su
|finding cells where the formula results in no entry ("") and delete those cells using VBA||9||29|
|VBA: Issue calling multiple procedures located in different modules.||4||22|
|Excel 2007 Comparing Cell Contents with IF Statements||12||38|
|enable formatting rows through Thsworkbook VBA code||5||15|