Find/Replace Cell Values with Named Ranges

[enk529]

Hi,

I have a number of named ranges that I need to find/replace data in.

For example, in range "PAPKGC" there are three variables: F, P, and X. For "F", the cell needs to contain the word "Flat". "P" is to contain "Package" and "X" is to be blank. Range "PASIDE" also contains 2 variables. I am to concatenate any cells with a value of 2 with "/pk" and any cells with a value of 1 are to be blank.

So my big question is: How can I use the named ranges to find and replace this data using a VBA macro?

This is what I'm trying, but I have no idea what I'm doing.

Please Login or Register  to view this content.

Any help is appreciated!

-G

[StephenR]

Do you mean that if a cell has 'F' in it you want to replace it with 'Flat'? If so, why not just use Find and Replace from the worksheet?

[seckert]

Try something like this:

Please Login or Register  to view this content.

Hope this helps

SAE