Specifically, I am trying to change the data range when a row is added to the table.
I am teaching myself, with only the Excel help as a reference. If someone can tell me the proper command, I can decipher the syntax and application.

If someone can tell me the proper command, I can decipher the syntax and application.

What proper command?

Dear,
You can use instance of Excel as Appexcel and then use its range as follows:

Myvariable = Application.myrange("A3")

RAJENDRA SHAH

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.