Offsett and replace range

**jeppenedved** · 07-09-2019, 02:21 PM

Hi!
I'm going mad about this. I want select a cell (merged over 4 rows), click a button with a macro that offsets 5 cells to the right, then marks an area from there to the end of my Formulas (i'm thinking xlToRight) and 4 rows down (same hight as the merged cell) and in that area replace "madness" with "yey". Please help me how that's done!
Thanks!

**dmcgov** · 07-09-2019, 03:10 PM

can you upload a sample workbook? tough to work out the details with what you have given.

**jolivanes** · 07-09-2019, 11:58 PM

And, if you have formulas in that Range, you can't replace them with another value without replacing your formulas.

Site security will not allow me to put some code in so that is in the attached .txt file.

**jeppenedved** · 07-10-2019, 03:13 AM

Originally Posted by jolivanes

And, if you have formulas in that Range, you can't replace them with another value without replacing your formulas.

Site security will not allow me to put some code in so that is in the attached .txt file.

That is exactly how I was thinking. Thanks! The replace will find a dummy text in a few index match Formulas and replace it with the name of a workbook that the Formulas is supposed to refer to. Seem to work fine. Thanks!

**Pepe Le Mokko** · 07-10-2019, 03:16 AM

Originally Posted by jolivanes

Site security will not allow me to put some code in so that is in the attached .txt file.

Hi
could you please explain what went wrong? Normally there should be no problem posting code ?

Please Login or Register  to view this content.

**jolivanes** · 07-10-2019, 10:28 AM

Hi Pepe.
The Sucuri warning would not let me Post.
I tried it again with this Post (Copy and Paste the Text from the .txt file) and it came up with the warning again
"Access denied. Sucuri Website Firewall." and a whole bunch of additional info.
See attached picture (IP address blacked out by me)