| 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 |
| 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) | |||
Threaded Mode
