On Sep 18, 11:14*pm, Sinner wrote:
On Sep 18, 5:54*pm, "Bob Phillips" wrote:





Yes, and two of us replied. You haven't reverted on those.

--
__________________________________
HTH

Bob

"Sinner" wrote in message

...
On Sep 17, 6:46 pm, "Bob Phillips" wrote:

My mum always use to start a sentence with Dear ... when she was about to
tell me I was being stupid. There was a tone as well, but maybe Sinner
meant
the same ... :-)

--
__________________________________
HTH

Bob

"Peter T" <peter_t@discussions wrote in message

...

"Sinner" wrote in message

Dear can't we define it as a dynamic name in sheet and use that
name in code instead of range??

Does that mean "Oh dear..." or "Dear Bob....", or "That's too
expensive..."

Are you looking to replace OldWords(i) with NewWords(i) in all cells in
the sheet, or do something else.

Regards,
Peter T- Hide quoted text -

- Show quoted text -

I think i didn't post the reply properly. Did anyone of you got the
reply?? : (
Bob & Peter.

Thx.- Hide quoted text -

- Show quoted text -

O : (

Bob : ) I use dear to everyone.. a habbit i.e. : ) so it was dear
Bod : )

Dear both actually I was looking for a way to replace text in a sheet
'data' base on criteria in a sheet 'temp'. The criteria is in

I have already tried with vlookup but its very time consuming.
Secondly the the ranges of both data & criteria are dynamic. So for
above code, I have to change the range as per requirement. Lets say I
define the data range as a name 'DATA' and criteria as 'CRT'. This way
the macro will be intact & if the ranges changes, I will need to alter
the name range rather than the range values in code.

Lastly the replacement should be irrespective of CaSE, case, CASE
sensitivity.
The previous code replaced words exactly as mentioned in the 'Temp'
sheet which it should not do.

Sample file is athttp://www.savefile.com/files/1777260

Thx for your replies.- Hide quoted text -

- Show quoted text -

Dim OldWords As Range
Dim NewWords As Range

Set OldWords = Range("A2:A14")
Set NewWords = Range("H5:H17")
For i = 1 To OldWords.Cells.Count


NewWords.Cells(i, 1).Copy OldWords.Cells(i, 1)
Next i


I want the Range(Old List), Range(New list) to be a defined name
How do I do that??