Scroll Column in Available Coding

[ofd2008]

Hi,
l add formula for single column with macro. How do I add other columns at the same time?

Please Login or Register  to view this content.

This encoding process from B3 to B202. l want to make this coding for C3-C202,D3-D202,E3-E202,...,DN3-DN202. Of course, at this stage, Column letter is changing to the right in the formula.

in B3 "=SUM('iletim'!H" & j & ":H" & j + 14 & ")+SUM('radyasyon'!F" & j & ":F" & j + 14 & ")+SUM('diger'!K" & a & ":K" & a + 10 & ")"

in C3 "=SUM('iletim'!I" & j & ":I" & j + 14 & ")+SUM('radyasyon'!G" & j & ":G" & j + 14 & ")+SUM('diger'!L" & a & ":L" & a + 10 & ")"

in D3 "=SUM('iletim'!J" & j & ":J" & j + 14 & ")+SUM('radyasyon'!H" & j & ":H" & j + 14 & ")+SUM('diger'!M" & a & ":M" & a + 10 & ")"

Continues until to DN3.

Regards.
Sorry my language.

[nathansav]

Duplicate post, saved twice

[nathansav]

Have a try yourself, look at your own code

.Range("B" & i)

So something similar to that. Or you could use offset ...

[Richard Buttrey]

Personally I'd hold a master formula above your data in a named cell say 'MyFormula'. Make sure the formula when copied across from B3:DN202 gives the right results. A quick look suggests that the column references should be relative. And for picking up the right J value use

Please Login or Register  to view this content.

in the sum formula.


Then in your macro simply use

Please Login or Register  to view this content.

Avoid loops for this sort of stuff wherever possible. With large ranges they are usually very slow.

[ofd2008]

Thank you so much.
Nice Day.