A Macro to create a grid

0

I am trying a project to use Excel macro(s) to create a 9x9 grid of boxes.  In each box, I will have a letter ('A', 'B', etc.)  then a couple of blank lines, then a randomly genterated set of four characters (for example g%6H).  Each time I press F9, a new set of random characters get made.  I am stuck on, how do I use macros to "draw" my grid, that I then populate with the letter, spaces, and random characters in each cell of the grid.  Any ideas how I start with making a grid?

Answer
Discuss

Answers

0

The best way forward is to use the Macro Recorder to record your key strokes as you create the grid manually. That will give you code from which you can start developing the code you will actually use. It will also give you a visual of the desired result which you can use to explain your ideas to those you might ask for help.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login