The following code is a macro I typed into a module.$$

Sub Numbers$()$

'this macro puts number patterns in columns

$$

'use a For loop to add numbers to rows $1$ to $100$

For rowcounter $=1$ To $100$

$$

$$ Cells$($rowcounter$,1).$Value $=$ rowcounter$$ 'column $1$ has $1,2,3,...$

$$ Cells$($rowcounter$,2).$Value $=$ rowcounter $^2$ 'column $2$ has $1,4,9,...$

$$ Cells$($rowcounter$,3).$Value $=$ rowcounter $^0\mathrm{.}5$ 'column $3$ has $1,2^0\mathrm{.}5,3^0\mathrm{.}5,...$

$$

Next rowcounter

$$

End Sub

$$

Copy the above code into your module and add the following to the above code.$$ Make sure to add your own comments for this new code.$$ To test this code you can use the same steps as the instructions I gave for testing a recorded macro.

$1.$ In column $4$ put the sequence of number log$(1),$ log$(2),$ log$(3),...$ for $100$ rows.

$2.$ In column $5$ put the sequence of numbers $1+1^2,2+2^2,3+3^2,...$ for $100$ rows.

After updating the code, paste your macro back into this document.

$$