How to tell the Macros to execute the script for all rows and not just a set amount of rows?

Asked Apr 21 '23 at 19:17

Active Apr 21 '23 at 19:21

Viewed 27 times

Macros are new to me. I'm working on a Macros project where the number of rows varies constantly. However, the number of Columns will not change. The problem is the script only runs for a set amount of rows. Debugging revealed that it operates according to how macros were recorded. Here is my sample code -

Selection.AutoFill Destination:=Range("J2:J559")

So it executes only upto 559 records. How can I get the script to execute for every row?

edited Apr 21 '23 at 19:17

braX

11,506
5
20
33

asked Apr 21 '23 at 19:17

newuser

Find the last row first, and then substitute the variable holding that value for the `559` - `Range("J2:J" & lastRow)` – braX Apr 21 '23 at 19:18
How do I do this? I am not a developer. Thanks – newuser Apr 21 '23 at 20:05

How to tell the Macros to execute the script for all rows and not just a set amount of rows?

0 Answers0