Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an Excel 2007 file that came from one of our vendors that has
237,000 rows on "Sheet1". While I have Excel 2007 on a 2nd workstation (alongside of Excel 2003), our finance department only has Excel 2003. I understand Excel 2003 has approx a 65,000 row limit per sheet. Divide these rows up into 65k chunks and it comes out to about 3.646 (4) sheets. Does anyone have a code sample that will take 4 blocks of 65k rows each from Sheet1 and move them to Sheet2, Sheet3, Sheet4, & Sheet5? Thanks, RLN |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 excel autofilter change back to 2003? | Excel Discussion (Misc queries) | |||
CONVERTING Excel 2003 Commands to 2007 | Excel Discussion (Misc queries) | |||
Converting a 2007 Excel Spreadsheet w/ 2003 | Excel Discussion (Misc queries) | |||
CONVERTING OFFICE 97-2003 EXCEL FILES TO 2007 EXCEL | Excel Discussion (Misc queries) | |||
converting office excel 2007 to excel 2003 | New Users to Excel |