View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ciupe ciupe is offline
external usenet poster
 
Posts: 1
Default VBA newbie - can i search the spreadsheet based on the active cell?

Hi Guys.

I'm new to VBA... and untill i get a book to help me out, let me giv
you guys a try.

I want to search my sheet with the value in the active cell (or
speciffic cell). Is that possible?

I'm trying to do a simple inventory sheet. I enter the item numbe
(0024 for example), and excel reports the row its in.

I can make it fancier from there but i need excel to return the row th
result is in.

Tell me what functions in vba to look up, or some sample code. I'
sure i can decipher it. Thanx :

--
Message posted from http://www.ExcelForum.com