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

Report
-
Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 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
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
465
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!