Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this macro but I have a problem with it working when I add more data.
I guess this macro starts from the top and doesnt recognize since its already done it. I think I need an "if. then" line but not sure how to exacute it. pls hlp. thanks. Sub seperatedata() Worksheets("DIE STATUS").Activate CELLCount = 2 With Worksheets("Die status") Do While Cells(CELLCount, "A") < "" Number = Val(Cells(CELLCount, "A")) Text = Cells(CELLCount, "A") Text = Trim(Mid(Text, InStr(Text, " "))) .Cells(CELLCount, "A") = Number .Cells(CELLCount, "C") = Text CELLCount = CELLCount + 1 Loop End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Loop Macro | Excel Programming | |||
Do until loop with use of another macro in loop | Excel Programming | |||
how to put a loop in a macro? | New Users to Excel | |||
Macro - Loop or Next | Excel Programming | |||
Loop Macro | Excel Programming |