| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a variable nuimber of rows
I want to copy the most recent 10 rows (excluding the header row) from
worksheet A to worksheet B. My problem is how do I define a variable number of rows if there are fewer than 10 lines completed? I do not want to copy any blank lines. I am fairly new to VBA and am struggling to work out the code for this so any help will be gratefully appreciated. John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofil on variable rows, delete extract and show remaining rows | Excel Programming | |||
| Inserting and copying Rows based on a variable | Excel Programming | |||
| Copying (variable) rows from another spreadsheet | Excel Programming | |||
| Macro for copying a value to a variable no. of rows | Excel Discussion (Misc queries) | |||
| Copying range to variable number of rows | Excel Programming | |||
Threaded Mode
