Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to use varibles in a function such as "ROWS
(2:5).Select" (see line 70 & 80 of code below) to allow for looping such as: For example if SAMPLE_NUMBER=4 I want to insert the copied cells in 3 different places. 10 For x = 1 To (Sample_Number - 1) 20 'Copy the original 4 rows 30 Rows("2:5").Select 40 Application.CutCopyMode = False 50 Selection.Copy 60 'Insert copied cells 70 y = 2 + (x * 4) 'move down four rows 80 Rows(y:y).Select 'THIS DOES NOT WORK 90 Selection.Insert Shift:=xlDown 100 'repeat this copy/paste moving 4 additional rows each time. 110 Next x |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing rows using formulas with variables | Excel Discussion (Misc queries) | |||
Selecting Rows using Long Variables | Excel Discussion (Misc queries) | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
More than 1 Variables | Excel Discussion (Misc queries) | |||
Lift Data from Rows to Populate HTML Variables | Excel Discussion (Misc queries) |