Member Avatar for Robert.kendall1

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.

  • 3 Contributors
  • 2 Replies
  • 82 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by RajendraShah
Member Avatar for jireh

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

What proper command?

Member Avatar for RajendraShah

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.