Input Cell to create table with input # of rows

I am trying to use a value from 1-256 to populate a table with 3 columns. The 3 columns are fixed and and it will always have 3. I have been looking but can't find something in excel to do this.

The goal of this program will be to reset each time they enter a different number of rows.

Please help, its for a project at school!!!

Hi

the general idea of homework is to learn you something, not really to have it been done by others.

I suggest you start your project, then come back for help if something goes wrong

Good luck

Originally Posted by arthurbr

Hi

the general idea of homework is to learn you something, not really to have it been done by others.

I suggest you start your project, then come back for help if something goes wrong

Good luck

Arthur,

I am well aware that is the general idea. This is literally only 1 part out of 50 that I have to do for this homework and it is something that I have been stuck on all morning. I have a ton of other parts to do once the table is generated. I'm not asking anyone to do my homework, just to help me establish how to create a table of 3 columns with the rows being variable depending on a input cell. I have also started working on my project for the last several days creating the layout and how I want to achieve it.

Option Explicit
Sub Macro2()


ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$C$4"), , xlNo).Name = _
"Table2"
Range("F17").Select
ActiveSheet.ListObjects("Table2").Resize Range("$A$1:$C$10")
Range("H30:H31").Select
End Sub


This is what I have currently, and I got this mostly from the Macro Recorder. Is there any way to modify it so that when the table is created it has the number of rows that I input it to be?