Excel 2013 macro

[oldraider67]

Hello everyone,

I hope not too many of the members and their families have contracted the virus. If, so I hope you and your family members recover quickly.

I am trying to recreate a maco I used to use in Excel 13.

Basically what it did was to take the information (music titles,artists, and CD) in a spread sheet and add random numbers to the next column. I then, manually selected the work sheet and and resorted
the worksheet by number from lowest to highest

This would give me a good mix. I might not use certain numbers in any particular mix if, for example, that would put two of the same artists for my target of 15 or 16 titles on a new CD for myself.

I still have the code on line and it worked fine. I have used it Now, I am unable to insert the code in a macro. It also rejects the name I try to use for the macro. I've tried changing the security settings in the worksheet to no avail. I am using an .xlsm worksheet which I believe is the correct worksheet to use.

Any suggestion or help appreciated.

Thanks

oldraider67

 

[x BlueRobot]

I am unable to insert the code in a macro. It also rejects the name I try to use for the macro.

What file name are you using? Are you inserting any spaces and/or special characters?

 

[oldraider67]

Hi bluerobot,

Thanks for getting back so quickly.

I had used small macros in the past and never had a problem (other than writing the code)

I was undertaking another small project where the code would work but couldn't get it into a macro.

Being stubborn I kept playing around and eventually got it to work.

Your help was appreciated.

oldraider67

 

[x BlueRobot]

I'm glad you were to get it working, do you know what steps you took?

 

[oldraider67]

My method was the equivalent of the "hunt and peck" version of finding what would work.

I created a new spreadsheet to experiment on and reread some other online answers that I had bookmarked.

The answers suggested to those posters to select the developers tab as a start. However, from there the threads talked about creating a button to get into writing a macro. That lost me.

I went back a few days later and selected the developer tab. If I had not been so frazzled I would have seen the two buttons on the left side of the ribbon that dropped down for Visual Basic and Macros.

I still wasn't sure but I copied and pasted the macro I had into the VBA "work screen" (?) and ran it (i think) and it worked.

As you can see I found the solution by thinking a bit more, poking around and reading more, and tripling the amount of "harsh language" while poking around. Also, a great deal of luck.

This is probably a set of directions I would not give to anyone but it worked.

Thanks