Excel 2003: In a Macro,how to select a variable row length table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to create a macro that will perform functions upon multiple rows of
data. The number of rows of data will change every time.

Problem : I create a macro by recording. I select rows of data using
CTRL/down arrow on the last column and then selecting back to the first
column of the first data row. This appears to 'hard code' the number of rows
of data to be the number of rows that exists at the time of macro creation.

When I run the macro another time it then selects the same number of rows as
when the macro was created, which will then not match the new current data.
i.e. some rows are left unselected.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting all cells with content using a variable 3
writing a sort macro 2
varying table length in a MACRO 2
copy down to a certain row 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Help on Macro to hide empty rows 4
Macro to Sort A-Z a variable range of cells 1
Excel 2003 accepting error message in macro 2

Back
Top