Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to capture row of a string value
I need to capture the row of a selected text value. Example:
Sheets(1).Range("A1").value = "LM " "LM" is also located somewhere in column F of Sheet2 I need to lookup LM in column F of sheet2 and capture the row. How can I do that either as a formula in a cell or vb code? Glen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I capture a date? | Excel Discussion (Misc queries) | |||
Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
Median of Even Set; How to Capture them? | Excel Discussion (Misc queries) | |||
Up Capture | Excel Programming | |||
Time Capture... | Excel Programming |