| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit .find to one pass
The following code loops through certain columns and removes the last
character in the data. My data arrangement has changed a little and now the code continuously loops through the data removing the last character until there is not data. Its funny to watch but I need to fix it... How can I limit the code to make just one pass? Too bad there is not a "before" attribute. thanks Robert Do Until ActiveCell.Value = "" Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, lookat:= _ xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= False, SearchFormat:=False).Activate ActiveCell.Offset(1, 0).Select Do Until ActiveCell.Value = "" 'Copy the right-most character to the next column ActiveCell.Offset(0, 1).Value = Right$ (ActiveCell.Value, 1) 'Cut off the right-most character ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) 'ActiveCell = ActiveCell.Offset(1, 0) ActiveCell.Offset(1, 0).Select Loop ActiveCell.Offset(-r, 1).Select 'move up and to next column Loop |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit .find to one pass
Hi Robert
I think this should do it: Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, _ lookat:=xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Set Startcell = ActiveCell Do ActiveCell.Offset(1, 0).Select Do Until ActiveCell.Value = "" 'Copy the right-most character to the next column ActiveCell.Offset(0, 1).Value = Right$(ActiveCell.Value, 1) 'Cut off the right-most character ActiveCell.Value = Left$(ActiveCell.Value, Len(ActiveCell.Value) - 1) 'ActiveCell = ActiveCell.Offset(1, 0) ActiveCell.Offset(1, 0).Select Loop ActiveCell.Offset(-r, 1).Select 'move up and to next column FindNext.Activate Loop Until ActiveCell.Address = Startcell.Address Regards, Per "Robert H" skrev i meddelelsen ... The following code loops through certain columns and removes the last character in the data. My data arrangement has changed a little and now the code continuously loops through the data removing the last character until there is not data. Its funny to watch but I need to fix it... How can I limit the code to make just one pass? Too bad there is not a "before" attribute. thanks Robert Do Until ActiveCell.Value = "" Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, lookat:= _ xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= False, SearchFormat:=False).Activate ActiveCell.Offset(1, 0).Select Do Until ActiveCell.Value = "" 'Copy the right-most character to the next column ActiveCell.Offset(0, 1).Value = Right$ (ActiveCell.Value, 1) 'Cut off the right-most character ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) 'ActiveCell = ActiveCell.Offset(1, 0) ActiveCell.Offset(1, 0).Select Loop ActiveCell.Offset(-r, 1).Select 'move up and to next column Loop |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit .find to one pass
One way:
Dim rFound As Range Dim sAddr As String With ActiveSheet.Cells Set rFound = .Find( _ what:="LC", _ after:=.Item(.Rows.Count, .Columns.Count), _ LookIn:=xlValues, _ Lookat:=xlPart, _ searchorder:=xlByColumns, _ searchdirection:=xlNext, _ MatchCase:=False) If Not rFound Is Nothing Then sAddr = rFound.Address Do With rFound .Offset(0, 1).Value = Right$(.Text, 1) .Value = Left$(.Text, Len(.Text) - 1) End With Set rFound = .FindNext(after:=rFound) Loop Until rFound.Address = sAddr End If End With In article , Robert H wrote: The following code loops through certain columns and removes the last character in the data. My data arrangement has changed a little and now the code continuously loops through the data removing the last character until there is not data. Its funny to watch but I need to fix it... How can I limit the code to make just one pass? Too bad there is not a "before" attribute. thanks Robert Do Until ActiveCell.Value = "" Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, lookat:= _ xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= False, SearchFormat:=False).Activate ActiveCell.Offset(1, 0).Select Do Until ActiveCell.Value = "" 'Copy the right-most character to the next column ActiveCell.Offset(0, 1).Value = Right$ (ActiveCell.Value, 1) 'Cut off the right-most character ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) 'ActiveCell = ActiveCell.Offset(1, 0) ActiveCell.Offset(1, 0).Select Loop ActiveCell.Offset(-r, 1).Select 'move up and to next column Loop |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit .find to one pass
Per, the code manipulates the first column correctly but at the
FindNext.Activate line I'm receiving a Runtime Error 424 "Object Required" error. I tried to fix it but did not make any progress. thanks Robert On Dec 18, 11:57*am, "Per Jessen" wrote: Hi Robert I think this should do it: Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, _ * * lookat:=xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, _ * * MatchCase:=False, SearchFormat:=False).Activate Set Startcell = ActiveCell Do * * ActiveCell.Offset(1, 0).Select * * Do Until ActiveCell.Value = "" * * * * 'Copy the right-most character to the next column * * * * ActiveCell.Offset(0, 1).Value = Right$(ActiveCell.Value, 1) * * * * 'Cut off the right-most character * * * * ActiveCell.Value = Left$(ActiveCell.Value, Len(ActiveCell.Value) - 1) * * * * 'ActiveCell = ActiveCell.Offset(1, 0) * * * * ActiveCell.Offset(1, 0).Select * * Loop * * ActiveCell.Offset(-r, 1).Select 'move up and to next column * * FindNext.Activate Loop Until ActiveCell.Address = Startcell.Address Regards, Per "Robert H" skrev i ... The following code loops through certain columns and removes the last character in the data. *My data arrangement has changed a little and now the code continuously loops through the data removing the last character until there is not data. Its funny to watch but I need to fix it... How can I limit the code to make just one pass? Too bad there is not a "before" attribute. thanks Robert Do Until ActiveCell.Value = "" * * * *Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, lookat:= _ * * * * * *xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= * * * * * *False, SearchFormat:=False).Activate * * * * * ActiveCell.Offset(1, 0).Select * * * * * * * *Do Until ActiveCell.Value = "" * * * * * * * * * *'Copy the right-most character to the next column * * * * * * * * * *ActiveCell.Offset(0, 1).Value = Right$ (ActiveCell.Value, 1) * * * * * * * * * *'Cut off the right-most character * * * * * * * * * *ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) * * * * * * * * * *'ActiveCell = ActiveCell.Offset(1, 0) * * * * * * * * * *ActiveCell.Offset(1, 0).Select * * * * * * * *Loop * * *ActiveCell.Offset(-r, 1).Select 'move up and to next column Loop |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit .find to one pass
Per,
the code manipulates the first column correctly but at the FindNext.Activate line I'm receiving a Runtime Error 424 "Object Required" error. I tried to fix it but did not make any progress. thanks Robert On Dec 18, 11:57*am, "Per Jessen" wrote: Hi Robert I think this should do it: Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, _ * * lookat:=xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, _ * * MatchCase:=False, SearchFormat:=False).Activate Set Startcell = ActiveCell Do * * ActiveCell.Offset(1, 0).Select * * Do Until ActiveCell.Value = "" * * * * 'Copy the right-most character to the next column * * * * ActiveCell.Offset(0, 1).Value = Right$(ActiveCell.Value, 1) * * * * 'Cut off the right-most character * * * * ActiveCell.Value = Left$(ActiveCell.Value, Len(ActiveCell.Value) - 1) * * * * 'ActiveCell = ActiveCell.Offset(1, 0) * * * * ActiveCell.Offset(1, 0).Select * * Loop * * ActiveCell.Offset(-r, 1).Select 'move up and to next column * * FindNext.Activate Loop Until ActiveCell.Address = Startcell.Address Regards, Per "Robert H" skrev i ... The following code loops through certain columns and removes the last character in the data. *My data arrangement has changed a little and now the code continuously loops through the data removing the last character until there is not data. Its funny to watch but I need to fix it... How can I limit the code to make just one pass? Too bad there is not a "before" attribute. thanks Robert Do Until ActiveCell.Value = "" * * * *Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, lookat:= _ * * * * * *xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= * * * * * *False, SearchFormat:=False).Activate * * * * * ActiveCell.Offset(1, 0).Select * * * * * * * *Do Until ActiveCell.Value = "" * * * * * * * * * *'Copy the right-most character to the next column * * * * * * * * * *ActiveCell.Offset(0, 1).Value = Right$ (ActiveCell.Value, 1) * * * * * * * * * *'Cut off the right-most character * * * * * * * * * *ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) * * * * * * * * * *'ActiveCell = ActiveCell.Offset(1, 0) * * * * * * * * * *ActiveCell.Offset(1, 0).Select * * * * * * * *Loop * * *ActiveCell.Offset(-r, 1).Select 'move up and to next column Loop- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit .find to one pass
JE,
Reading my original post, I realize I did not explain the data structure. There is a header row with columns of data below it. I need to find the columns with "LC" in the header cell and then perform the manipulation in all the data cells in the column (below the header cell). You code sugestion code manipulates the cells containing "LC" in the header row instead of the cells below the header row. thanks Robert On Dec 18, 12:26*pm, JE McGimpsey wrote: One way: * * Dim rFound As Range * * Dim sAddr As String * * With ActiveSheet.Cells * * * * Set rFound = .Find( _ * * * * * * * * what:="LC", _ * * * * * * * * after:=.Item(.Rows.Count, .Columns.Count), _ * * * * * * * * LookIn:=xlValues, _ * * * * * * * * Lookat:=xlPart, _ * * * * * * * * searchorder:=xlByColumns, _ * * * * * * * * searchdirection:=xlNext, _ * * * * * * * * MatchCase:=False) * * * * If Not rFound Is Nothing Then * * * * * * * * sAddr = rFound.Address * * * * * * * * Do * * * * * * * * * * With rFound * * * * * * * * * * * * .Offset(0, 1).Value = Right$(.Text, 1) * * * * * * * * * * * * .Value = Left$(.Text, Len(.Text) - 1) * * * * * * * * * * End With * * * * * * * * * * Set rFound = .FindNext(after:=rFound) * * * * * * * * Loop Until rFound.Address = sAddr * * * * End If * * End With In article , *Robert H wrote: The following code loops through certain columns and removes the last character in the data. *My data arrangement has changed a little and now the code continuously loops through the data removing the last character until there is not data. Its funny to watch but I need to fix it... How can I limit the code to make just one pass? Too bad there is not a "before" attribute. thanks Robert Do Until ActiveCell.Value = "" * * * * Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, lookat:= _ * * * * * * xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= * * * * * * False, SearchFormat:=False).Activate * * * * * *ActiveCell.Offset(1, 0).Select * * * * * * * * Do Until ActiveCell.Value = "" * * * * * * * * * * 'Copy the right-most character to the next column * * * * * * * * * * ActiveCell.Offset(0, 1).Value = Right$ (ActiveCell.Value, 1) * * * * * * * * * * 'Cut off the right-most character * * * * * * * * * * ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) * * * * * * * * * * 'ActiveCell = ActiveCell.Offset(1, 0) * * * * * * * * * * ActiveCell.Offset(1, 0).Select * * * * * * * * Loop * * * ActiveCell.Offset(-r, 1).Select 'move up and to next column Loop- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit .find to one pass
Robert
Change FindNext.Activate to: Cells.FindNext.Activate Regards, Per On 19 Dec., 14:19, Robert H wrote: Per, the code manipulates the first column correctly but at the FindNext.Activate line I'm receiving a Runtime Error 424 "Object Required" error. I tried to fix it but did not make any progress. thanks Robert On Dec 18, 11:57*am, "Per Jessen" wrote: Hi Robert I think this should do it: Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, _ * * lookat:=xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, _ * * MatchCase:=False, SearchFormat:=False).Activate Set Startcell = ActiveCell Do * * ActiveCell.Offset(1, 0).Select * * Do Until ActiveCell.Value = "" * * * * 'Copy the right-most character to the next column * * * * ActiveCell.Offset(0, 1).Value = Right$(ActiveCell.Value, 1) * * * * 'Cut off the right-most character * * * * ActiveCell.Value = Left$(ActiveCell.Value, Len(ActiveCell.Value) - 1) * * * * 'ActiveCell = ActiveCell.Offset(1, 0) * * * * ActiveCell.Offset(1, 0).Select * * Loop * * ActiveCell.Offset(-r, 1).Select 'move up and to next column * * FindNext.Activate Loop Until ActiveCell.Address = Startcell.Address Regards, Per "Robert H" skrev i ... The following code loops through certain columns and removes the last character in the data. *My data arrangement has changed a little and now the code continuously loops through the data removing the last character until there is not data. Its funny to watch but I need to fix it... How can I limit the code to make just one pass? Too bad there is not a "before" attribute. thanks Robert Do Until ActiveCell.Value = "" * * * *Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, lookat:= _ * * * * * *xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= * * * * * *False, SearchFormat:=False).Activate * * * * * ActiveCell.Offset(1, 0).Select * * * * * * * *Do Until ActiveCell.Value = "" * * * * * * * * * *'Copy the right-most character to the next column * * * * * * * * * *ActiveCell.Offset(0, 1).Value = Right$ (ActiveCell.Value, 1) * * * * * * * * * *'Cut off the right-most character * * * * * * * * * *ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) * * * * * * * * * *'ActiveCell = ActiveCell.Offset(1, 0) * * * * * * * * * *ActiveCell.Offset(1, 0).Select * * * * * * * *Loop * * *ActiveCell.Offset(-r, 1).Select 'move up and to next column Loop- Hide quoted text - - Show quoted text -- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit .find to one pass
Per, It works now. I had to make one more modification:
Cells.findnext(ActiveCell).Activate otherwise it would just go back an work the same column one time and then exit. Thanks very much for the help Robert Final code: Sub ConvPMFLTSMoveLCIDtoNextCol() Dim r As Long Dim r2 Dim startCell As Range Dim findnext r = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row - 1 Range("a1").Select 'Code mosdifications from Per Jessen Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, _ lookat:=xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Set startCell = ActiveCell Do ActiveCell.Offset(1, 0).Select Do Until ActiveCell.Value = "" 'Copy the right-most character to the next column ActiveCell.Offset(0, 1).Value = Right$(ActiveCell.Value, 1) 'Cut off the right-most character ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) 'ActiveCell = ActiveCell.Offset(1, 0) ActiveCell.Offset(1, 0).Select Loop ActiveCell.Offset(-r, 1).Select 'move up and to next column Cells.findnext(ActiveCell).Activate Loop Until ActiveCell.Address = startCell.Address End Sub On Dec 19, 9:04*am, Per Jessen wrote: Robert Change FindNext.Activate to: Cells.FindNext.Activate Regards, Per On 19 Dec., 14:19, Robert H wrote: Per, the code manipulates the first column correctly but at the FindNext.Activate line I'm receiving a Runtime Error 424 "Object Required" error. I tried to fix it but did not make any progress. thanks Robert On Dec 18, 11:57*am, "Per Jessen" wrote: Hi Robert I think this should do it: Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, _ * * lookat:=xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, _ * * MatchCase:=False, SearchFormat:=False).Activate Set Startcell = ActiveCell Do * * ActiveCell.Offset(1, 0).Select * * Do Until ActiveCell.Value = "" * * * * 'Copy the right-most character to the next column * * * * ActiveCell.Offset(0, 1).Value = Right$(ActiveCell.Value, 1) * * * * 'Cut off the right-most character * * * * ActiveCell.Value = Left$(ActiveCell.Value, Len(ActiveCell.Value) - 1) * * * * 'ActiveCell = ActiveCell.Offset(1, 0) * * * * ActiveCell.Offset(1, 0).Select * * Loop * * ActiveCell.Offset(-r, 1).Select 'move up and to next column * * FindNext.Activate Loop Until ActiveCell.Address = Startcell.Address Regards, Per "Robert H" skrev i ... The following code loops through certain columns and removes the last character in the data. *My data arrangement has changed a little and now the code continuously loops through the data removing the last character until there is not data. Its funny to watch but I need to fix it... How can I limit the code to make just one pass? Too bad there is not a "before" attribute. thanks Robert Do Until ActiveCell.Value = "" * * * *Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, lookat:= _ * * * * * *xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= * * * * * *False, SearchFormat:=False).Activate * * * * * ActiveCell.Offset(1, 0).Select * * * * * * * *Do Until ActiveCell.Value = "" * * * * * * * * * *'Copy the right-most character to the next column * * * * * * * * * *ActiveCell.Offset(0, 1).Value = Right$ (ActiveCell.Value, 1) * * * * * * * * * *'Cut off the right-most character * * * * * * * * * *ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) * * * * * * * * * *'ActiveCell = ActiveCell.Offset(1, 0) * * * * * * * * * *ActiveCell.Offset(1, 0).Select * * * * * * * *Loop * * *ActiveCell.Offset(-r, 1).Select 'move up and to next column Loop- Hide quoted text - - Show quoted text -- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn -- Hide quoted text - - Show quoted text - |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit .find to one pass
Hi Robert
Thanks for your reply, I'm glad you made it work. Regards, Per "Robert H" skrev i meddelelsen ... Per, It works now. I had to make one more modification: Cells.findnext(ActiveCell).Activate otherwise it would just go back an work the same column one time and then exit. Thanks very much for the help Robert Final code: Sub ConvPMFLTSMoveLCIDtoNextCol() Dim r As Long Dim r2 Dim startCell As Range Dim findnext r = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row - 1 Range("a1").Select 'Code mosdifications from Per Jessen Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, _ lookat:=xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Set startCell = ActiveCell Do ActiveCell.Offset(1, 0).Select Do Until ActiveCell.Value = "" 'Copy the right-most character to the next column ActiveCell.Offset(0, 1).Value = Right$(ActiveCell.Value, 1) 'Cut off the right-most character ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) 'ActiveCell = ActiveCell.Offset(1, 0) ActiveCell.Offset(1, 0).Select Loop ActiveCell.Offset(-r, 1).Select 'move up and to next column Cells.findnext(ActiveCell).Activate Loop Until ActiveCell.Address = startCell.Address End Sub On Dec 19, 9:04 am, Per Jessen wrote: Robert Change FindNext.Activate to: Cells.FindNext.Activate Regards, Per On 19 Dec., 14:19, Robert H wrote: Per, the code manipulates the first column correctly but at the FindNext.Activate line I'm receiving a Runtime Error 424 "Object Required" error. I tried to fix it but did not make any progress. thanks Robert On Dec 18, 11:57 am, "Per Jessen" wrote: Hi Robert I think this should do it: Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, _ lookat:=xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Set Startcell = ActiveCell Do ActiveCell.Offset(1, 0).Select Do Until ActiveCell.Value = "" 'Copy the right-most character to the next column ActiveCell.Offset(0, 1).Value = Right$(ActiveCell.Value, 1) 'Cut off the right-most character ActiveCell.Value = Left$(ActiveCell.Value, Len(ActiveCell.Value) - 1) 'ActiveCell = ActiveCell.Offset(1, 0) ActiveCell.Offset(1, 0).Select Loop ActiveCell.Offset(-r, 1).Select 'move up and to next column FindNext.Activate Loop Until ActiveCell.Address = Startcell.Address Regards, Per "Robert H" skrev i ... The following code loops through certain columns and removes the last character in the data. My data arrangement has changed a little and now the code continuously loops through the data removing the last character until there is not data. Its funny to watch but I need to fix it... How can I limit the code to make just one pass? Too bad there is not a "before" attribute. thanks Robert Do Until ActiveCell.Value = "" Cells.Find(what:="LC", After:=ActiveCell, LookIn:=xlValues, lookat:= _ xlPart, searchorder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= False, SearchFormat:=False).Activate ActiveCell.Offset(1, 0).Select Do Until ActiveCell.Value = "" 'Copy the right-most character to the next column ActiveCell.Offset(0, 1).Value = Right$ (ActiveCell.Value, 1) 'Cut off the right-most character ActiveCell.Value = Left$(ActiveCell.Value, Len (ActiveCell.Value) - 1) 'ActiveCell = ActiveCell.Offset(1, 0) ActiveCell.Offset(1, 0).Select Loop ActiveCell.Offset(-r, 1).Select 'move up and to next column Loop- Hide quoted text - - Show quoted text -- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - Getting pass the 3 condition limit | Excel Discussion (Misc queries) | |||
| Cells.Find: Why can't I pass a variable? | Excel Discussion (Misc queries) | |||
| Conditional Formatting - Getting pass the 3 condition limit | Excel Discussion (Misc queries) | |||
| How do I my find pass word in excel | Setting up and Configuration of Excel | |||
| Find a Value Pass Row 99 | Excel Programming | |||
Linear Mode
