Creating a macro that does not copy amount of rows from file

Closed
CM - Sep 1, 2015 at 01:32 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Sep 8, 2015 at 11:39 AM
Hello,

I am trying to create a macro that does NOT copy the amount of rows in the file the macro was recorded in.

For example:
The macro is specific to the amount of rows in the file when you're recording the macro. If there are 1700 rows in the file when you create the macro, it's carrying those formulas down for 1700 rows. However, if I download data for one day (as we often will), it still pastes the formulas for 1700 rows even though there's only ~20 actual rows in the new file.

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Sep 8, 2015 at 11:39 AM
Hi CM,

Could you post your code, so we can advise how to change the fixed 1700 rows to a dynamic input based number of rows. Or do you want to count the number of rows used and use that number in the code?

Best regards,
Trowa
0