Hello there, What ever i have understood from your question and providing you the answer for it *" type =row()" *to get the required result i.e row number If this is not the case try others answers to get what you are expecting.
Regards Ahmedhonest On Thu, Dec 18, 2008 at 10:32 PM, ShellyGirl <shellywilloug...@yahoo.com>wrote: > > Hello, I am trying to create a macro. I would like for user to be > able to type in a search criteria and hit search button. I would like > the macro to search a range of cells for the input and return the row > number of the first search result. Any help will be greatly > appreciated... > > I think my main problem is, I don't know how to create a formula to > return a row number. > > > > -- Ahmed Bawazir --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
