Help needed with Golf Tournament spreadsheet.

[Robsony]

Hi,

I have a spreadsheet that was written to manage a small 16 player golf tournament. 5 round of golf. I have amended the code to give me the points scoring that I want but I have inadvertently messed something up as I get the error
run time error 1004
the sort reference is not valid, make sure that its withing the data you want to sort and the first sortby box isnt the same or blank.
the debug shows :
Range("a9").Sort key1:=Columns(z), Order1:=xlDescending, Header:=xlGuess
highlighted. Can anyone help if i send you the file?

 

[Joe4]

Welcome to the Board!

Please show us your complete code (as it is referencing variables like "z" which you have not shown us how they are being calculated), as well as a screen image of the data you are running this on.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Also, when posting VBA code, please use the VBA code tags to make your code more readable. See: How to Post Your VBA Code