Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Command
What is the programming for the find command in visual
basic? I want to find a cell that contains the same value as another cell. I want to know the row number of the cell. This is what I have but it is way too slow. I think that if I use the find command instead of Do until it will be much faster. Thank you (i is the counter in wks_A) (n is the counter in wks_S) For i = 2 To ArcviewFinalRow n = 2 Do Until (wks_A.Range("B" & i).Value = wks_S.Range("B" & n).Value Or n = SectionsFinalRow) n = n + 1 Loop wks_A.Range("C" & i).Value = wks_S.Range("C" & n).Value Next i |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Command
Hi
have a look in the VBA help for .find -- Regards Frank Kabel Frankfurt, Germany "Adam" schrieb im Newsbeitrag ... What is the programming for the find command in visual basic? I want to find a cell that contains the same value as another cell. I want to know the row number of the cell. This is what I have but it is way too slow. I think that if I use the find command instead of Do until it will be much faster. Thank you (i is the counter in wks_A) (n is the counter in wks_S) For i = 2 To ArcviewFinalRow n = 2 Do Until (wks_A.Range("B" & i).Value = wks_S.Range("B" & n).Value Or n = SectionsFinalRow) n = n + 1 Loop wks_A.Range("C" & i).Value = wks_S.Range("C" & n).Value Next i |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Command | Excel Discussion (Misc queries) | |||
Find (or Ctrl-F) command | Excel Discussion (Misc queries) | |||
FIND command | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
FIND Command | Excel Programming |