Find - Replace - Sort: code upgrade

[markos97]

hi,
I need your help to modified below codes.
I want replace for example in columns A:C the numbers 3, 4, 12 to number 99, in columns D:F the numbers 5, 6, 18 also to number 99, in columns G:I the numbers 2, 4, 6 to number 99, and so on, in this case every 3 columns. Below code doesn't work.

Please Login or Register  to view this content.

And I need help to modified, code to sort for example every 3 columns

Please Login or Register  to view this content.

especially, below lines

Please Login or Register  to view this content.

to simpliest one line

I hope so understand
Thanks

[MaczaQ]

first part (Replace) solved here:

Please Login or Register  to view this content.

[markos97]

thanks a lot,
today I try your code in a few hours, I hope so work
but, I need simpliest record this line:

Please Login or Register  to view this content.

, not ranges, A:C and so on, but for example every 3 columns
and below line

Please Login or Register  to view this content.

can I this way?:

Please Login or Register  to view this content.

Maybe someone have an idea for second code?

ps. I'm using excel 2000 and 2003

thank you once more again maczaq

[MaczaQ]

Hello,

Updated code below. I created a loop through each 3 columns till macro will find empty range (coArr is without changes). That what You wrote about coArr is only notation. Thats mean it is the same as I wrote only using "_" you can break a line and write code in two or more lines

Please Login or Register  to view this content.

You should remember that macro takes values to change from coArr for next index every loop is step to next area (3 columns) If you will have more columns you should remember to update coArr Array otherwise you will get an error about "Subscription out of range"

[markos97]

yeah, that's it!
thank you again maczaq

any other help to simpliest record second code?:

Please Login or Register  to view this content.