I have a code to fill an Excel cell with a value using the function provided by Excel.
.Cells(10, 1).Value = "Sum(" & .Cells(irow, icol) & _
":" .Cells(irow + 5, icol) ")"
The above code does not work. I could not use Cells() to refer to a particular cell in the function, but I need to use A1, B1... etc as written in excel's formula bar. However the cells I'm referring for my function is not fixed at design time, so I use variables instead. Hmm anyone know how to manipulate it?
Thanks so much.