Find and Replace All With Excel VBA- in a range

Hi all ,

Good day !!

I have requirement where my date needs replace set of list against set of another list example listed below

006=005
032=030
034=030
047=040
C41=C01


however , I tried a formula but that gave me in entire active sheet , I need that only in particular range .

Please Login or Register  to view this content.

Could some one help me please .



regrads,

Hudson

Maybe:

Please Login or Register  to view this content.

Hi john,

above given formula fetch could replace in entire sheet , which I don't want that way... I need it in particular range or column (Example : I want that values to be replaced only in column B or C ).

can you advice please.?.

It should replace only the C1 value ie - sht.Range("C:1"), can you attach a sample where it's replace every cell in the sheet?

John - thanks again !!!

here is the data . kindly advice please

John- can you please ensure also when we replace it with desire values it should replace in text format or text values .


Appreciate your assistance .

Hudson

Based on your sample what would you want too happen? I'm unclear on that.

John - in column C values should change with find and replace ..

for example :
in column C any value with 006 should change to 005
and 032 with 030 so on like below


006=005
032=030
034=030
047=040
C41=C01

column B and C or one and the same anything is ok for me ..

could some one please advice me , on my request please !!!

i am not clear of what your are saying ... however i have tried by changing both .... ( C:C) and ( C1) .

The argument to Range can be a string that gives a range in the same syntax used in a worksheet formula. "C:1" is not a valid range. The colon is used to specify a contiguous rectangular range from an upper-left cell to a lower-right cell. So "C1:D2" is a range with 4 cells, and "C:E" is a range that specifies the entire columns for C, D, and E. But "C:1" doesn't mean anything and that line of code will generate an error when it executes.

From the context of what you are doing I think "C:C" is correct. But it sounds like the code still isn't doing what you want. Your post #8 is clear and basically says the same thing you started with. How is the code different than that?