Code for inserting 300 rows

[griffindor2020]

Hello,

I was wondering if someone could help me develop a code to insert 300 rows after a specific row.

For example I would like to add 300 rows right after row 80 000 in my data set.

Hope someone will get back to me soon !

 

[Fluff]

How about

Rows(80001).Resize(300).Insert

 

[griffindor2020]

How about

Rows(80001).Resize(300).Insert

I tried running this and nothing happened.

 

[MARK858]

How did you try running it? and where did you put the code?

 

[Fluff]

Did you actually mean after row 80,000 ?
That's a lot of rows of data.

 

[griffindor2020]

How did you try running it? and where did you put the code?

I tried running by going into Visual Basic, then created a module and copy pasted the script that Fluff made.

Did you actually mean after row 80,000 ?
That's a lot of rows of data.

I know, I do have an insanely high volume of data :') can you imagine I was trying to sort this manually without knowing anything about macros and VBA ? :')

But yes, I need 300 rows to be inserted right after row 80 000 !

 

[Fluff]

Did you put it inside a sub, like

Sub griffindor()
   Rows(80001).Resize(300).Insert
End Sub

 

[griffindor2020]

Did you put it inside a sub, like

Sub griffindor()
   Rows(80001).Resize(300).Insert
End Sub

I tried but it gave me an error.

But I will use this code soon and let you know how it goes

 

[griffindor2020]

Did you put it inside a sub, like

Sub griffindor()
   Rows(80001).Resize(300).Insert
End Sub

Works like a charm

 

[Fluff]

You're welcome & thanks for the feedback.