Plamanrich
New Member
- Joined
- Apr 22, 2002
- Messages
- 1
have a bunch of spreadsheets that are of varying rows of data. I want to record a mraco that will number the row numbers
and provide some formating in certain cells and column-total certain columns. The data is all in the same location column-wise,
only the number of rows differs. When I record the macro, it specifies that bottom of the columns (ie; Range "A32"). The
next spreadsheet may have 50 rows but the macro does everything as if there are 32 rows of data. How can I tell the macro
to adjust for more rows of information.
Thanks in advance.
and provide some formating in certain cells and column-total certain columns. The data is all in the same location column-wise,
only the number of rows differs. When I record the macro, it specifies that bottom of the columns (ie; Range "A32"). The
next spreadsheet may have 50 rows but the macro does everything as if there are 32 rows of data. How can I tell the macro
to adjust for more rows of information.
Thanks in advance.