Excel VBA cells function.

[mattm99]

I need to write a function that writes a 10x10 table and in each cell writes its position. For example in cell A1 it would say "A1" and so on. It basically just needs to label the cells from A1 to J10. We are supposed to use the macro recorder i just dont know how you would label them all without individually labeling them. I am struggling with the characters as well. Thanks

[Leith Ross]

Hello mattm99,

Welcome to the Forum!

Here is a hint, set the cell's value to its address using the Address property.

[Whizbang]

No macro needed. Try this formula, copied to the desired range:

=ADDRESS(ROW(),COLUMN(),4)

[Leith Ross]

@ Whizbang

Look again...

We are supposed to use the macro recorder

[Whizbang]

Ah... Homework assignment, eh? Now I regret my direct answer.