simora
12-27-2019, 08:22 PM
Happy Holidays Everyone:
What is the best way to organize a VBA copy / paste to the next available row after a specific cell
I want to copy an Entire row if the cell in Column A is in a list in My Range which I will define,
For example ActiveSheet.Range( "A5:A8")
and paste the entire row to the next available row after Row 80.
I have Specific rows already Populated with data. Rows 90 & 100 for example.
I will loop through a Range("A3:A50") to select what rows to copy based on if the cell in Column A is in the List that I have defined.
Eventually, I will paste another set of rows past row xx etc...etc...
What is the best way to organize a VBA copy / paste to the next available row after a specific cell
I want to copy an Entire row if the cell in Column A is in a list in My Range which I will define,
For example ActiveSheet.Range( "A5:A8")
and paste the entire row to the next available row after Row 80.
I have Specific rows already Populated with data. Rows 90 & 100 for example.
I will loop through a Range("A3:A50") to select what rows to copy based on if the cell in Column A is in the List that I have defined.
Eventually, I will paste another set of rows past row xx etc...etc...