clean up code

This is some (poor) vba code I wrote in order to take multirow information and unpivot it for a table that will be used elsewhere. I know unpivoting can be done in power pivot or even just in excel, but in my situation, having a macro run this code would be a whole hell of a lot easier. Thank...

I have a UDF that I wrote .... nothing fancy, but I could sure use some help cleaning up. It is very basic and I am not 100% sure where or how I should clean it up so that it is easier on the eyes, easier to follow (doesn't make one cringe just looking at it), better coding...

Hello Excel Experts. Please feel free to ask me questions about my sample investment spreadsheet. I'm not sure how much of it I need to explain to get my question(s) answered. The basic idea is the "Projection" tab summarizes the potential investments based on the top table, where you plot...

See code below: Sub runallmacros() Dim wbSource As Workbook Dim wsDest As Worksheet Dim row As Integer, os As Integer Set wsDest = ThisWorkbook.Worksheets("File Copier") row = 2 os = 0 With wsDest Do While .Range("K" & row).Value <> ""...