Create a table with size based on a formula (VBA)

Hi,

I need a macro to create a table with a size based on a formula and in which the values in the table are also formulas. An example is provided in attachment.

How can I do this?

Thanks

You will have to be more explicit in the details of what you are wanting to accomplish. Your attachment does not help to explain or clarify your post.

Please provide a more clear explanation and upload a revised attachment that includes an example of the results you want.

How critical is the "formula" part of this? Once you move to VBA, it's simpler to just put the values directly into the table.

I was simply referring to the fact that once you move to VBA you can edit your "data" and rerun your macro to reassert your table at anytime, there's no need to maintain formulas in the table itself, it seems like plumbing you just don't need once you go to VBA.

This shows what I mean. I moved all the Input cells to the left so they do not interfere with a table size that could be any size. This will create the table starting in column H and go out as far as needed.

1) Put data in column B
2) Fill out the start, end and increments section
3) Click the button to create the table.
4) Change any of the inputs and click the button again to reassert the table

Please Login or Register  to view this content.