Loop to next cell and row and edit formula

**MrMyagiii** · 07-02-2019, 03:44 AM

Hi all,

I`m having a hard time with this loop. The formula`s that are in use are a bit more complicated than my example but the workings are quite similar. For some reason i cannot add sample file so i`ll try to be as clear as possible.
-- A -- B -- C -- D -- E
1 1
2 formula 2
3 formula formula 3
4 formula formula formula 4
5 formula formula formula formula 5
6

This is what the file looks like. Cell A2 contains the following formula: =A$1+10. Cell A3 also has =A$1+10. Then B3 should get =B$2+10, same for B4. So basically i want to copy the formula down 1 cell and then to the next column, but with the previous rownumber +1. So B4 formula to C4 but instead of =B$2+10 i want C$3+10. I tried using activerow but can`t figure this one out.

Kind regards,

**Pepe Le Mokko** · 07-02-2019, 06:36 AM

You can add a sample file by clicking the " Go advanced" button and then " Manage attachments " ( the paperclip is OOO for the moment )

**MrMyagiii** · 07-02-2019, 09:50 AM

File added. I want the yellow fields to be filled with a macro that also changes the formula

**Marc L** · 07-02-2019, 10:29 AM

As a beginner starter :

PHP Code:


Sub Demo() 
    Dim C% 
    For C = 3 To 5:  Cells(C + 1, C).Resize(2).FormulaR1C1 = "=R" & C & "C+10":  Next 
End Sub

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

**MrMyagiii** · 07-08-2019, 03:19 AM

Ok so a bit more challenging than i thought. I added a new testfile. Columns H and I are correct. I need macro to fill and adjust the formula for the next columns untill P.

**jindon** · 07-08-2019, 03:54 AM

Try, (no error handling)

Please Login or Register  to view this content.

**MrMyagiii** · 07-11-2019, 10:14 AM

I think you got the other formula than the one i needed. This is copying the v.lookup where i needed the =(I$3*(0,5^(DATUMVERSCHIL(I$1;$G5;"D")/6,67)))

Loop to next cell and row and edit formula

LinkBack

Thread Tools

Rate This Thread

Display

Loop to next cell and row and edit formula

Re: Loop to next cell and row and edit formula

Re: Loop to next cell and row and edit formula

Hi ! Try this ‼

Re: Hi ! Try this ‼

Re: Loop to next cell and row and edit formula

Re: Loop to next cell and row and edit formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA - Loop through workbooks, edit specific sheet and cell - easy

[SOLVED] Blank cell gives error 13 (Mismatch) in loop - edit code to accommodate for blanks

Macro to edit formulas within a cell/loop through folder

Edit cell formula using VBA

Edit this macro code to loop and end

can't edit a cell with a formula

How can i get an If formula in excel to edit another cell?

Bookmarks

Bookmarks

Posting Permissions