Search results

The file and code from "Monty" works for me !

The SpecialCells change puts a 0 in Vol A instead of the players name.

Is there a fix for this code if Col A is formulas ?

Here is the file

After Intersect(Columns(1).SpecialCells(2).Areas(1).EntireRow, Columns(1).Resize(, myCol).EntireColumn).Rows.Count I get Error 1004 No cells were found.

In this code Dim myCol As Long myCol = Rows(1).Find("Games").Column Application.DisplayAlerts = False With Intersect(Columns(1).SpecialCells(2).Areas(1).EntireRow, Columns(1).Resize(, myCol).EntireColumn) .Offset(-1).Resize(.Rows.Count + 1).Copy .Offset(.Rows.Count - 11)...

Try =CONCATENATE(A1,B1,C1) ?

Can you talk through how this works ?

What about some thing like :- =40 -COUNTA( 'Level 1'!D3:D35)

Thanks.

Any tip on how to suppress " Do you want to replace contents of the destination cells" message ?

To you ! Thanks for the code, Have got hang of the sort code, "Red" code giving trouble.

Error 1004 No cells were found. Fixed this now.

Its very nearly what I need, just need to sort any "Ties" based on no. of Red cells.

It looks like it only sorts 1 col and has no VBA (that i can see )

Any code to sort this by highest Red colour and ties by lowest Green, So that it looks like bottom ?