For more depth see Install a Macro or User Defined Function on my Formula page.Speed and efficiency considerations can be seen in Proper, and other Text changes and in Slow Response.Hello I am working on some VBA projects and found my way to your explanation at I am fairly new to the VBA, having come from a world of SQL, and I don't think I would have ever figured this out.Thank you again for the post and for specifically showing the changes in Red/Green.For example, if it is your goal to maintain data integrity in a format that can be accessed by multiple users, Access is your best choice, whereas Excel is better suited for complex numerical data that you want to analyze in depth.
Find the complete documentation here: Documentation See an example of how to install Excel Add-Ins (Excel 2007 and above): Installation Download the Scrape HTML Add In here.The following macro attempts to fix that and is dependent on there being a value in Column A for every row in the original. Calculation = xl Automatic '--Excel 95 Application.This macro will move cells up if there is an empty cell above and column A cell is empty. Column For r = Rcnt To 2 Step -1 If Is Empty(Cells(Rcnt, 1)) Then For c = 1 To Ccnt If Not Is Empty(Cells(r, c)) Then If Not Is Empty(Cells(r - 1, c)) Then Go To notthis End If Next c For c = 1 To Ccnt If Not Is Empty(Cells(r, c)) Then Cells(r - 1, c) = Cells(r, c) End If Next c Cells(r, 1). Screen Updating = True End Sub The Del Cells Up macro will delete all empty cells within the highlighted range and move the cells and formatting up from below. (Althought, for additional reason, the late binding is not force any error in my case).(It could work for first time, but never more before closing Access and reopen). I''ve been struggling with this problem for a while.