How to Use a Variable to Control the Number of New Rows Inserted

[AnyOldName]

I'm using this line of code to add 12 empty rows at the top of a worksheet

Var_RawData_Worksheet.Rows("1:12").Insert shift:=xlShiftDown


I'd like to use a variable to control the number of rows but can't figure out the syntax, what I need is something like:

VARIABLE_NO = 12

Var_RawData_Worksheet.Rows("1: VARIABLE_NO").Insert shift:=xlShiftDown

Apologies for what is probably a very stupid question, my VBA is coming on but sometimes the basic stuff beats me.

 

[Fluff]

Where is the number of rows going to come from?

 

[gallen]

do you mean:

[COLOR=#333333]Var_RawData_Worksheet.Rows("1:" &  [/COLOR][I][B]VARIABLE_NO[/B]).Insert shift:=xlShiftDown[/I]

 

[AnyOldName]

Where is the number of rows going to come from?

The variable value will be read in from a cell value

 

[Fluff]

How about something like

VARIABLE_NO = Sheets("Sheet1").Range("A1").Value
Var_RawData_Worksheet.Rows(1).Resize(VARIABLE_NO).Insert shift:=xlShiftDown

 

[AnyOldName]

do you mean:

[COLOR=#333333]Var_RawData_Worksheet.Rows("1:" &  [/COLOR][I][B]VARIABLE_NO[/B]).Insert shift:=xlShiftDown[/I]

Yes, that works, thanks.