Find the location of cell
Closed
sunny2u86
-
Feb 4, 2012 at 10:17 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 5, 2012 at 04:20 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 5, 2012 at 04:20 AM
Related:
- Find the location of cell
- Postal address of my location - Guide
- The system could not identify your location viber - Guide
- Elden ring save location - Guide
- Find location by latitude and longitude google earth - Guide
- Chrome extensions location - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 4, 2012 at 09:43 PM
Feb 4, 2012 at 09:43 PM
suppose data is from A1 to a7 as follows
1
2
3
rv
4
5
6
now you want fo find out the cell address of "rv" and enter that cell address in some other location
use this formula
="A"&MATCH("rv",$A$1:$A$7,0)
as you have not given where the data is, what data is to be found etc you have to modify the formula to suit you.
1
2
3
rv
4
5
6
now you want fo find out the cell address of "rv" and enter that cell address in some other location
use this formula
="A"&MATCH("rv",$A$1:$A$7,0)
as you have not given where the data is, what data is to be found etc you have to modify the formula to suit you.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 5, 2012 at 04:20 AM
Feb 5, 2012 at 04:20 AM
for this particular problem macro is NOT necessary, formula will do
A constraint is that id more "rv" are in the column it will find the cell address of only the first occurrence.
if you still need the macro
assuming data is from A1 to a7 as given in previous message
the macro will be
A constraint is that id more "rv" are in the column it will find the cell address of only the first occurrence.
if you still need the macro
assuming data is from A1 to a7 as given in previous message
the macro will be
Sub test()
Dim r As Range, cfind As Range, add As String
Worksheets("sheet1").Activate
Set r = Range(Range("a1"), Range("a1").End(xlDown))
Set cfind = r.Find(what:="rv", lookat:=xlWhole)
If Not cfind Is Nothing Then
add = cfind.Address
MsgBox add
End If
End Sub
Feb 5, 2012 at 01:16 AM