Ike
04-23-2015, 05:56 AM
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 and formula cells.
I would like a macro, that I can add to a pre-existing code, that would find the first empty row of column B. Column B does not contain any data validation or formulas.
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 if needed. Say, next week I need to change it to 600.
Thank you in advance. :)
Alvin
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 and formula cells.
I would like a macro, that I can add to a pre-existing code, that would find the first empty row of column B. Column B does not contain any data validation or formulas.
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 if needed. Say, next week I need to change it to 600.
Thank you in advance. :)
Alvin