Recently a friend asked me to fix a macro that she was working on to compare two columns in Excel and if the cell in Column A did not exist in any cell of Column B, then add it to Column C. You can make check both columns for miss matches by copy/pasting Column B to Column A and vice versa to check both lists and maybe someone will find it handy =) Sub Subset() Dim Acell As Range 'Acell is a range of 1 or more cells Dim Bcell As Range 'Bcell is a range of 1 or more cells Dim Ccell As Range 'Ccell is a range of 1 or more cells Dim Index As Integer 'Index is the current row we are saving to in the Ccell Index = 1 'Start the Index at 1 Dim found As Boolean 'Remove the hidden space 160 Range("A1:A1000").Replace What:=Chr(160), Replacement:="", LookAt:=xlPart Range("B1:B1000").Replace What:=Chr(160), Replacement:="", LookAt:=xlPart For Each Acell In Range("A1:A1000") Acell...
Loading SOS For sometime now I have relied on windbg to show me exceptions occuring in SharePoint. You can attach windbg to any process and view the .NET exceptions occuring at runtime between the process and the CLR, even handled exceptions. Usually the true source of the error is hidden in a wrapper and rethrown as an irrelevant exception. Thank you SharePoint. In order to view these exceptions we can attach windbg to either the w3wp.exe related to your IIS website running the SharePoint site by clicking Start => Run => inetmgr => Click on server => Worker processes, or by powershell if you are executing or can execute the relevant command through powershell you can attach the to powershell.exe process. After launching windbg and attaching to a process we need to load the Sons of Strike SOS.dll to enable viewing managed exceptions in windbg, without the SOS dll we can only view native code. To do this within the windbg command prompt of the atta...
Comments
Post a Comment