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

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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