I suggest that this is a good time to learn VBA, so perhaps you could buy a book on it such as Microsoft's Excel 2003 Step by Step.
I suggest that this is a good time to learn VBA, so perhaps you could buy a book on it such as Microsoft's Excel 2003 Step by Step.
Best regards,
Ray
So what I asked about search from bottom to top is possible?
-Dan
www.ksvp.org
Yes if you build your own function!
I will figure it out then and share my results
Hi, Dan. If you want to just use this in your code, rather than building a function, in your find command, just use:
andAfter:=Cells.SpecialCells(xlCellTypeLastCell)
SearchDirection:=xlPrevious
Thank you. Im afraid I may be headed to a Black List for asking too many questions. Perhaps I should spend more time in the New Users Forum helping with the easy questions.
I dont want to upset anyone, and usually I try to ask basic questions but I added the code this time because most people seem to want to know exactly what Im doing and what I have to work with.
If anyone thinks I take take take, and never give, Excel is something I am learning and I am active on about 10 other forums some where I am the expert, and I dont mind sharing what I know there. I understand the frustration if someone gave me a good answer and I asked them to detail how every line works. Of course, some answers I have received came with detailed instructions on what every line does, which is fine with me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks