Hi,

I have a worksheet that has data validation and formulas in several cells across a row and in every row down to row 500. As rows with data above row 500 are regularly deleted (not cleared), then row 500 no longer has the data validation cells.

I would like to find the first empty row of column B
Copy the entire Row with data validation and formulas
Paste to all rows down to a maximum of row 500. I would like to be able to change row 500 to any other number of rows when needed. Say, next week I need to change it to 600.


Thank you in advance.

Alvin