Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loops
Thanks to the people who answered my last post. Problem 2. I have written a loop which works but I want it to stop when the activecell has the value "fuggle". It stops for a few seconds at cell fuggle then goes round again. The code is below any ideas? Sub Customer() ' ' Customer Macro ' Macro recorded 07/07/2005 by James Fuggle ' ' Sheets.Add ActiveSheet.Name = "Customers" Sheets("Duration and Consumables Bookin").Select Do While ActiveCell < "fuggle" Cells.Find(What:="customer", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Copy Sheets("Customers").Select ActiveCell.Offset(1, 0).Range("A1").Select ActiveSheet.Paste Sheets("Duration and Consumables Bookin").Select ActiveCell.Offset(1, 0).Range("A1").Select Loop End Sub -- fugfug ------------------------------------------------------------------------ fugfug's Profile: http://www.excelforum.com/member.php...o&userid=24950 View this thread: http://www.excelforum.com/showthread...hreadid=385196 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loops
Sub Customer()
' ' Customer Macro ' Macro recorded 07/07/2005 by James Fuggle ' ' Sheets.Add ActiveSheet.Name = "Customers" Sheets("Duration and Consumables Bookin").Select Range("A1").Select Cells.Find(What:="fruggle", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate rw = ActiveCell.Row Range("A1").Select Do While ActiveCell.Row < rw Cells.Find(What:="customer", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate If ActiveCell.Row = rw Then Exit Do Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Copy Sheets("Customers").Select ActiveCell.Offset(1, 0).Range("A1").Select ActiveSheet.Paste Sheets("Duration and Consumables Bookin").Select ActiveCell.Offset(1, 0).Range("A1").Select Loop End Sub -- Regards, Tom Ogilvy "fugfug" wrote in message ... Thanks to the people who answered my last post. Problem 2. I have written a loop which works but I want it to stop when the activecell has the value "fuggle". It stops for a few seconds at cell fuggle then goes round again. The code is below any ideas? Sub Customer() ' ' Customer Macro ' Macro recorded 07/07/2005 by James Fuggle ' ' Sheets.Add ActiveSheet.Name = "Customers" Sheets("Duration and Consumables Bookin").Select Do While ActiveCell < "fuggle" Cells.Find(What:="customer", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Copy Sheets("Customers").Select ActiveCell.Offset(1, 0).Range("A1").Select ActiveSheet.Paste Sheets("Duration and Consumables Bookin").Select ActiveCell.Offset(1, 0).Range("A1").Select Loop End Sub -- fugfug ------------------------------------------------------------------------ fugfug's Profile: http://www.excelforum.com/member.php...o&userid=24950 View this thread: http://www.excelforum.com/showthread...hreadid=385196 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loops
Thanks alot, works now -- fugfu ----------------------------------------------------------------------- fugfug's Profile: http://www.excelforum.com/member.php...fo&userid=2495 View this thread: http://www.excelforum.com/showthread.php?threadid=38519 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do loops within Do loops | Excel Programming | |||
Using For - Next Loops in VB | New Users to Excel | |||
Loops | Excel Programming | |||
for each loops | Excel Programming | |||
Loops etc. | Excel Programming |