View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Brymor Brymor is offline
external usenet poster
 
Posts: 17
Default Can locating "FIND" results be made easier on the eyes? [Offic

Thanks for your prompt reply, Im very grateful.
The extra sheets I wish to locate/highlight are in the same workbook. Sheet
1 is the most important listing and Sheets 2-3-4 are identical layout, [in
fact direct copies of sheet 1] and dont need accessing as often as Sheet 1.
Ive tried to look up a number that I knew was in Sheet 2, when Sheet 1 is
on the screen having changed the Find Option to Within Workbook, and
hoped the correct sheet would appear on screen with the desired number
highlighted.
I hope thats enough info for you but if not pse let me know and Ill try
harder. Youll have to make allowances for my age, Im 70 today!
By the way, where are you/ I presume youre in the States. Im in Cardiff,
(Welsh) Wales UK.

--
Brymor


"JLatham" wrote:

A little more detail about the second half would help. Do the other sheets
already exist, have to be created on the fly if they don't exist? How are
those sheets laid out, etc. etc. Describe the process in more detail?

The answer is YES - it is the details that will have to be worked out.

Yes, Chip's got some great code laying around. Wish I'd have found those
pages ages ago, would have saved me lots of coding time in some my own work,
I'm sure. As you say, the row highlighter may be very beneficial. I created
one of those here in our offices for one of our people in the accounting
department. She has troubles following rows across wide sheets, and the
'highlight current row' setup I built for her was just the ticket.

"Brymor" wrote:


--
Brymor

"What a clever guy you are". I knew there'd be someone out there with the
answer.
It works a treat. That Chip Pearson must be some super Whiz-kid. His
Rowliner Add-in, on his site, looks very interesting also. I may give that a
go for another project.

All that remains now is for me to find a solution to my second question. Any
ideas?
Thanks anyway, you're a ***star****
"JLatham" wrote:

A little routine that Chip Pearson has available may assist you:
http://www.cpearson.com/excel/excelM.htm
Scroll down the page (or use Find) to the topic
Highlighting The Active Cell
and put that code in your workbook's code module.

To do that, right-click on the Excel icon just to the left of the [File]
menu entry and choose View Code at the bottom of the list that appears. Cut
and paste Chip's code in it. The first line (the definition line of the Sub)
may appear in red text because it may get split across two lines improperly,
Just edit it to make it a single line.

"Brymor" wrote:

I have many thousand Names listed against separately numbered cells on many
A4 pages on one worksheet.
e.g. Numbered Cell: BZ,2012[with No 20251] against Named Cell: CA,2012 [with
NAME]

Then, when I want to view a name against a particular number I use the
Edit-Find facility, which works well. But, with so many on the sheet, its
not easy to spot the one thats selected. So, is there a way one can
incorporate a colour thats automatically applied to the selected cell?
My eyes are Very Old and would appreciate some assistance in spotting the
cell!

Also, is it possible to locate and automatically show Found numbers on
different sheets in the same workbook? with the sheets changing on each
Find request?