Consecutive integers

[ttropics]

I have to write the code such that when the button is pressed the next integer is appended to the end of thetable and its square (n^2) and root (SQR) are calculated and displayed in the table.

https://gyazo.com/79ad9088bdf3893edc4fa0165df1c2b5

Could anyone help me get started i have no idea what to do

 

[ttropics]

this is what i have so far

Columns("B:C").ColumnWidth = 22


range("a1").Value = "Number"
range("b1").Value = "Square of the Number"
range("c1").Value = "Square root of the Number"


range("a2:c2").Value = 1

 

[steve the fish]

Dont start a new thread about the same question within an hour or two or the original. It wastes peoples time.

 

[Fluff]

Continuation https://www.mrexcel.com/forum/excel-questions/1045992-loop-post5021407.html#post5021407

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).