Hi, I wonder whether someone could possibly help me please.
I'm trying to put together a script which will highlight the highest and second highest value for each column in a given range for multiple sheets.
I've started the script off below, which I think correctly creates the array of sheets and the starting row of each column.
Sub Highlight() Dim ws As Worksheet, Worksheet, LastRow As Long Const StartRow As Long = 5 Application.ScreenUpdating = False For Each ws In Worksheets(Array("Direct Activities", "Enhancements", "Indirect Activities", "Overheads", "Projects")) LastRow = ws.Cells(ws.Rows.Count, "B").End(xlUp).Row If LastRow >= StartRow Then End If ws.Columns("B:Q").AutoFit Next ws Application.ScreenUpdating = True End Sub
Now I did try to get some help here: http://www.excelforum.com/exce…ighlight-max-numbers.html but as you will see I seem to have hit a bit of brick wall.
I just wondered whether someone could possibly look at this please, and offer some guidance on how I may go about achieiving this.
Thank you and kind regards