Macro to select the 20 rows below the currently selected cell

[Buns1976]

Hi Everyone,

I have a macro that selects the cell in column A which contains the text "Freight Summary". "Freight Summary" is always in column A but can be in any row. I need to continue this macro by selecting the 20 rows below the cell containing "Freight Summary", copy those rows over to column B

Thanks,
B

 

[Buns1976]

Then you should be able to just do an insert

Sub Buns()
ActiveCell.Offset(1).Resize(20).Insert
End Sub

 

[MARK858]

selecting the 20 rows below the cell containing "Freight Summary"

By your image the row with Freight Summary moves over and so you don't need the Offset (and there aren't 20 rows)

Edit: What are you trying to say in your last post?

 

[Buns1976]

Got it! Thank you very much!!

By your image the row with Freight Summary moves over and so you don't need the Offset (and there aren't 20 rows)

Edit: What are you trying to say in your last post?

Correct on the 20 rows. I will use the same macro for 4 scenarios but alter the number of rows which seems to be consistant

 

[MARK858]

Happy you got it sorted, glad we could help.