Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Cell Address
I run a macro to find a value/text in a spread sheet. Instead of getting the
value from that cell, I want the address. Is there code that can do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Cell Address
instead of .value, use .address
"scottfoxall" wrote in message ... I run a macro to find a value/text in a spread sheet. Instead of getting the value from that cell, I want the address. Is there code that can do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Cell Address
This code looks for the string "asdf" in the current worksheet and
displays a message box with the address when it is found. If the string is not found it advises the user, as well. You can substitute your search string as a variable or as a hardcoded entry. Sub Find() On Error GoTo NotFound: Cells.Find(What:="asdf", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate MsgBox ActiveCell.Address End NotFound: MsgBox ("Search target not found.") End Sub |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Cell Address
Thankyou. & rated
"PCLIVE" wrote: instead of .value, use .address "scottfoxall" wrote in message ... I run a macro to find a value/text in a spread sheet. Instead of getting the value from that cell, I want the address. Is there code that can do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Address of Maximum value in Cell | Excel Worksheet Functions | |||
Insert Cell Contents in middle of web address | Excel Discussion (Misc queries) | |||
Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions |