Random Letter Copy and paste-Little help for a beginner

Hello everyone,

I have been "playing" with excel macros for the first time in my life in the last two hours and here is the first doubt that I have not been able to solve by myself. I know it must be very easy, but please, don't be so hard on me.

I want to introduce a random letter in a cell. That is what I have tried:

Please Login or Register  to view this content.

As you see, I use the random character function and I do a "copy-special paste" in order to get rid of the function itself and keeping just the value, so it won't ever change. What I don't like about this is that the cell keeps selected with that twinkling edge that appears after doing ctrl+c, and I don't want that. If I were not using a macro I would press ESC, but I don't know how to make the macro do this.

Well, that is my problem and my rudimentary attempted solution.

I would also want to ask for a good source of information to avoid posting this kind of threads in the future.

Thanks in advance.

Please Login or Register  to view this content.

Hi there,

Welcome to the forum!!

This should do it:

Please Login or Register  to view this content.

It would also be helpful to change your thread title to something more internet searchable to help others who may have the same or similar query from Little help for a beginner to something like Excel: Random Letter Generator or the like.

Thanks,

Robert

Thanks for both quick responses.

Edit: Could you please recommend me some novice guide to excel macros or VBA?