Relative Content

Tag Archive for excelvbaexcel-tables

How do I insert a variable range using VBA?

I’m creating a template for work, and I need to be able to insert a variable range from an input table which sits in “Inputs” into a form sheet, which sits in “Form”. The input table currently has a large preset array so that the user doesn’t have to change the range themselves (I work with those some might call “unskilled” at excel), and their inputs could range from anywhere from 2-75+ rows.