adding formula in empty row
 

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

adding formula in empty row
 

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" wrote in message
...
I am trying to add the formula in empty row.
Thanks...

adding formula in empty row
 

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" wrote in message
...
I am trying to add the formula in empty row.
Thanks...

adding formula in empty row
 

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" wrote in message
...
I am trying to add the formula in empty row.
Thanks...

adding formula in empty row
 

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