Thread: Macro Need
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave D-C Dave D-C is offline
external usenet poster
 
Posts: 13
Default Macro Need

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