Hey guys just a quick and painless question here for all the ladies and gents who are familiar with VBA:
Here is a macro I created and at the moment its placing the result (sum of a certain column) in the active cell (im assuming) and I was wondering how to put the result in a cell other than the active cell (say +4 columns or 4 columns to the right). Any suggestions??
Sub Test() Dim LR As Long With ActiveCell LR = .Offset(, -8).End(xlDown).Row - .Row .FormulaR1C1 = "=SUM(RC[-8]:R[" & LR & "]C[-8])" End With End Sub
oops.. double post
Sub Test() Dim LR As Integer With ActiveCell LR = .Offset(, -8).End(xlDown).Row - .Row End With Cells((ActiveCell.Row-4), (ActiveCell.Column-4)).FormulaR1C1 = "=SUM(RC[-8]:R[" & LR & "]C[-8])" End Sub
Or just make it a function.
Unfortunately theres an error with the line:
Cells((ActiveCell.Row-4), (ActiveCell.Column-4)).FormulaR1C1 = "=SUM(RC[-8]:R[" & LR & "]C[-8])"
Any Ideas??
yeah...
most likely row-41 or column-41.... or look at your sum formula.... maybe column-81
Eius accusantium harum esse quibusdam vero repudiandae. Neque iure est esse in qui ipsa in. Architecto sed rerum architecto velit. Omnis in ab dolores quasi quas. Facilis quis voluptates quas magni eos aut.
Id nihil dicta molestiae deleniti tempora est officiis. Ut est unde id quis voluptatibus consequuntur unde. Nam suscipit aut maiores dignissimos odio et unde. Aut dolores ut iste et expedita vitae. Consectetur est soluta debitis. Dignissimos nostrum id ut. Voluptas aliquid qui iste atque doloribus qui blanditiis veniam.
Vel vero quia deleniti et minima molestiae recusandae. Et pariatur hic ullam voluptatum. Est molestias et ullam necessitatibus repellat consequatur sapiente. Veniam et libero et ut ea facilis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...