(Solved) – VBA Macro paste same number of cells as the next column


I’m trying to copy and paste data from one sheet to another and need VBA to put in a macro that will allow me to copy a formula and paste it the same amount of rows as the column to the right (column B) The number of rows in column B will change each time. i.e column B has data in cells B2:B50 and need to copy my formula from A2:A50. I can’t just put “50” because the number of rows will change each time.

Any help is appreciated!

Leave a Reply

Your email address will not be published. Required fields are marked *