Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel2000: Insert a copy of row range
Hi
I need in VBA to add a 5-row range into a table (5 rows is a entry in table). The operation will be same as manually to copy a row range, and then insert copied cells to same location. All formats (cell merging included), formulas, row heights, etc. must be copied too. The code below copies the same range (initially, it has to be a pre-last entry in table - using the last one makes a mess from all formulas) over, instead inserting a new one. How to modify it? ..... For i = 1 To (varNeededEntries - varCurrentEntries) Sheets("Sheet1").Range(RowX & ":" & (RowX+4)).Copy (Sheets("Sheet1").Range(RowX & ":" & (RowX+4))) Next i ..... Thanks in advance! -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2000: Formatting a range as Text in VBA | Excel Programming | |||
Excel2000: How to copy data validation using VBA | Excel Programming | |||
Excel2000: Reading Named Range value from VBA | Excel Programming | |||
Excel2000: Copy all exept data | Excel Programming | |||
Excel2000: finding last row of used range | Excel Programming |