Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
After exporting a table from Access into Excel, I need to move the data down
45 rows via automation. This is working, but seems inefficient: Do While fr < 45 xlapp.Workbooks(strXlsFile).Worksheets(sn).Cells(f r + 1, "A"). _ EntireRow.Insert shift:=xlDown fr = fr + 1 Loop Is there a better way to move this contiguous block of cells? There is no other data in the worksheet, and the cells always begin at A1. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can references (to cells being sorted) move with the cells? | Setting up and Configuration of Excel | |||
Move cells according to value | Excel Discussion (Misc queries) | |||
Sorting cells: a list behind the cells do not move with the cell | Excel Discussion (Misc queries) | |||
Move 2 cells to right | Excel Discussion (Misc queries) | |||
Move cells | Excel Programming |