order=xldescending

I am sorting the following columns independently and in descending order, i.e. the largest value in each column will always be in the top row. However, I have several blank cells in the table. These are not actually blank, but rather the formula e.g. IFERROR(H2/I2,"") gives a blank answer. I...

Hello Having tried unsuccessfully to find a solution to the below issue on both google and old threads in this forum I kindly request any suggestions as to how to solve this problem. I'm simply trying to sort a range in an Excel file from Access, but it's erroring with everything I try. My...

Hello, I have a worksheet and have created this VBA to sort a range with two sort keys. First in descending order on Range N8 as the first key ... Sub sort_ruldown() Application.ScreenUpdating = False Sort.SortFields.Clear With Sort .SortFields.Add Key:=Range("N8")...

Hi all, My macro runs and saves a created workbook from the macro workbook. But the file that is saved corrupt and excel has to ask if the user wants to recover data whenever these files are produced. I have gone over all my code, and I suspect that the way I am sorting the data is buggy. Is...

Can someone help me loop this macro on all worksheets? (theres 47) Sub AM2_Format_Util_Template() ' ' AM2_Format_Util_Template Macro ' ' Columns("AC:AC").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False...