LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Solution :)

Keith R wrote:
Set cell = sheet.Cells.Find(label);

sets your "cell" range to a specific cell where you found the first match


Yes, this should find the first match of "label" on the sheet.

cell = cell.Cells(1, 2) ' one cell to the right

may set your range to a specific cell that doesn't include your match


This is intended. The function looks for the first occurrence of the
"label" argument, and then returns the value of the cell to the right of it.

The point is that I do not want to *prevent* duplicate matches when the
function is called more than once. Instead, I want to make it return the
exact same result each time it is called with the same arguments.

And, just by chance, I have come across the solution: If I change the
line "cell = cell.Cells(1, 2)" to "Set cell = cell.Cells(1, 2)", then it
works. Don't ask me why.

Jens
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I search for repeated numbers in same column MB New Users to Excel 1 October 28th 09 07:16 PM
How can I search for entries that are repeated in the workbook? Ivan Excel Worksheet Functions 4 May 23rd 07 02:17 AM
copy from B worksheet to A worksheet with NO repeated data tikchye_oldLearner57 Excel Discussion (Misc queries) 1 September 29th 06 06:56 PM
how can i know that my worksheet having repeated same values Prem Excel Worksheet Functions 1 August 1st 06 09:15 AM
Printing text in a repeated cell/row that is longer than repeated Valerie Dyet Excel Discussion (Misc queries) 1 February 13th 06 03:27 AM


All times are GMT +1. The time now is 01:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"