David04Ruiz
New Member
- Joined
- Aug 29, 2022
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
Hi all, I'm super new to macros and VBA. I run this macro on a daily basis and it always seems to get stuck when it reaches a specific line of code. It takes about a minute a or so to do a simple function which is just pulling down formulas. I will attach screenshots of what I'm trying to have it do and the lines of the code that are causing the slow down. I am just trying to drag the formula in columns A-C & E-T down to the last row based on the last row of column D (in this case row 583). The code highlighted in blue is what I think is achieving this but for some reason it takes a really long time to do this. Does anyone happen to know why or how I can speed this up? Any help is greatly appreciated!