I want to write an automated script, function is to look for in the excel spreadsheet is greater than the number nine characters, the same character to replace the same random Numbers, and does not randomly and the number of repeat, before make the table, the purpose of all the values less than nine thanks, each prawn!

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

reference 1st floor zhao4zhong1 response:

began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

When necessary, can also be after press Alt + F11 key, and then press F1 to view VBA for Excel online help,