adding formula in empty row

I am trying to add the formula in empty row.
Thanks...

I think you need to provide much more detail. You can add a
formula with code like

Range("A1").Formula = "=NOW()"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Asu" <[email protected]> wrote in message
news:[email protected]...
>I am trying to add the formula in empty row.
> Thanks...

Hi again
Thanks for the quick response. I am beginner for vba. I took some lessons
but it was not enough.
The problem is ;
I have got two worksheets. The second one has got some data. I need to sum
b+c+d columns and put the this value in first worksheet's f column. it is
okey I can do it. But the data must come on the first empty row in f column.
If you could help me i wold be appreciated.

"Chip Pearson" wrote:

> I think you need to provide much more detail. You can add a
> formula with code like
>
> Range("A1").Formula = "=NOW()"
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Asu" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to add the formula in empty row.
> > Thanks...
>
>
>

Perhap the following will help get you started:

Option Explicit

Sub SumSheet2()
Dim Sum1 As Long
Dim Sum2 As Long
Dim Sum3 As Long
Dim NextCell As Range

Set NextCell = Sheets("Sheet1").Range("F65536").End(xlUp).Offset(1, 0)
Sum1 = Application.Sum(Sheets("Sheet2").Range("B:B"))
Sum2 = Application.Sum(Sheets("Sheet2").Range("C:C"))
Sum3 = Application.Sum(Sheets("Sheet2").Range("D:D"))

NextCell = Sum1 + Sum2 + Sum3

Set NextCell = Nothing
End Sub


"Asu" wrote:

> Hi again
> Thanks for the quick response. I am beginner for vba. I took some lessons
> but it was not enough.
> The problem is ;
> I have got two worksheets. The second one has got some data. I need to sum
> b+c+d columns and put the this value in first worksheet's f column. it is
> okey I can do it. But the data must come on the first empty row in f column.
> If you could help me i wold be appreciated.
>
> "Chip Pearson" wrote:
>
> > I think you need to provide much more detail. You can add a
> > formula with code like
> >
> > Range("A1").Formula = "=NOW()"
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
> > "Asu" <[email protected]> wrote in message
> > news:[email protected]...
> > >I am trying to add the formula in empty row.
> > > Thanks...
> >
> >
> >

Hi Asu,
SInce you have multiple (completely different) answers and have not indicated any of them
answered your question, possibly by adding you mean inserting and
you might look at
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
to help you continue formulas down from previous rows.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm