rangen

Hi, I m trying to paste only the value from a merged cell ("C10:K10"), to the next empty cell in column N. The code I am using unsuccessfully is below: Range("C10:K10").Copy Range("N" & Rows.Count).End(xlUp).Offset(1).Select ActiveSheet.PasteSpecial xlPasteValues...

Hi, I am trying to copy the range of cells inside for loop. My intention to copy Range("N" & i to "U" & i) For this, I have written below code but the compiler is not happy with it. Any help, please. For i = 6 to 100 Range("N" & i : "U" & i).Copy Next i

I have been using this below code. It basically copies the value from cell H5 everytime it changes to the first empty cell in column N. The problem is I need to copy H5 and I5 when H5 changes. I have tried adding AND like this: ...Then sh.Range("N" & Range("N" & Rows.Count).End(xlUp).Row +...

Hi, How can i use "sum" function in ".Formulalocal=" my code in vba : Range("N" & CStr(ilkbos + 1)).FormulaLocal = "=(R[0]C[-1])+(R[1]C[-1])+(R[2]C[-1])+(R[3]C[-1])+(R[4]C[-1])" but i would use "sum" function like; Range("N" & CStr(ilkbos + 1)).FormulaLocal = "=sum(R[0]C[-1]):(R[4]C[-1])"...

hi! want to select range between activecell and a cell with name. get syntax error Dim n As String n = ActiveCell.Name.Name ActiveSheet.Range((ActiveCell), Range(n + "sist")).Select Selection.Cut help please,