Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable rows to be copied
I have multiple tabs in one spreadsheet. When the user enters a tab I have a
user form that asks for how many rows they would like to have. This could range from 1-250. The textbox info is placed in cell m2. I don't know how to copy range c15:k15 the number of times it takes to meet the users request. An example would be if they entered 5 in the textbox, select range c15:k15 and copy in down four times. Any help would be great. Tim Peter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable rows to be copied
Your description is not very clear. To expand Range("C15:K15") to five
rows: rng = Range("C15:K15") rng.Resize(5, 9) would increase the range size by five rows. "tpeter" wrote in message ... I have multiple tabs in one spreadsheet. When the user enters a tab I have a user form that asks for how many rows they would like to have. This could range from 1-250. The textbox info is placed in cell m2. I don't know how to copy range c15:k15 the number of times it takes to meet the users request. An example would be if they entered 5 in the textbox, select range c15:k15 and copy in down four times. Any help would be great. Tim Peter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable rows to be copied
Give this a try...
HowManyTimes = 5 Range("C15:K15").Resize(HowManyTimes).Value = Range("C15:K15").Value -- Rick (MVP - Excel) "tpeter" wrote in message ... I have multiple tabs in one spreadsheet. When the user enters a tab I have a user form that asks for how many rows they would like to have. This could range from 1-250. The textbox info is placed in cell m2. I don't know how to copy range c15:k15 the number of times it takes to meet the users request. An example would be if they entered 5 in the textbox, select range c15:k15 and copy in down four times. Any help would be great. Tim Peter |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable rows to be copied
If it is just copying, then:
Range("C15:K15").Copy Range("C15:K20") "tpeter" wrote in message ... I have multiple tabs in one spreadsheet. When the user enters a tab I have a user form that asks for how many rows they would like to have. This could range from 1-250. The textbox info is placed in cell m2. I don't know how to copy range c15:k15 the number of times it takes to meet the users request. An example would be if they entered 5 in the textbox, select range c15:k15 and copy in down four times. Any help would be great. Tim Peter |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable rows to be copied
try something like this:
Option Explicit Sub Main() Dim qrows As Long qrows = InputBox("How many rows") If qrows 0 Then Range("C15:k15").Copy Range("C16").Resize(qrows - 1).PasteSpecial xlPasteAll Application.CutCopyMode = False End If End Sub "tpeter" wrote: I have multiple tabs in one spreadsheet. When the user enters a tab I have a user form that asks for how many rows they would like to have. This could range from 1-250. The textbox info is placed in cell m2. I don't know how to copy range c15:k15 the number of times it takes to meet the users request. An example would be if they entered 5 in the textbox, select range c15:k15 and copy in down four times. Any help would be great. Tim Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign copied range to a variable | Excel Programming | |||
Inserting copied rows | Excel Worksheet Functions | |||
Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows | Excel Programming | |||
Stopping a constant variable cell from being copied. | New Users to Excel | |||
blank rows between copied rows | Excel Discussion (Misc queries) |