Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
ytayta555 wrote:
Ow , my God , Dave , you're incredible ! [etc.] You certainly made my day! You're welcome. Only one thing I'd like to know, and this thing only if it is possible, how must look the code, after the last row is filled (65536, I use Excel 2003 ) , to to continue the combination in the next sheet, .. Replace zRow = zRow + 1 with zRow = zRow + 1 If zRow 65536 Then zRow = 1 ActiveWorkbook.Sheets.Add End If I guess to view progress, you need to replace DoEvents ' to view progress with If zRow = 1 Then ActiveSheet.Columns.AutoFit Cells(zRow, 1).Select DoEvents ' to view progress Best to you, Dave D-C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |