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

Closed
CM - Sep 1, 2015 at 01:32 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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