diferrence

  • Thread starter Thread starter cecilia12345
  • Start date Start date
C

cecilia12345

im sorry if i sound silly but what´s the difference between the Excel
Worksheet Functions forums and the programming forum? arent they about
programming anyways?

sorry again, im a newbie...
 
cecilia12345 said:
im sorry if i sound silly but what´s the difference between the Excel
Worksheet Functions forums and the programming forum? arent they about
programming anyways?

sorry again, im a newbie...
Click to expand...

Worksheet functions are the formulas you put in the cells on a worksheet. In
the context of Excel, programming means the writing of code using VBA,
otherwise known as a macro.
 
thanks...
very helpfull...
but then i wonder if you can put formulas in cells through programming
 
Cecilia,

Yes you can.

Sub DemoFormula
Worksheets("Sheet1").Range("A1").Formula = "=$A$4+$A$10"End SubThat
would be entered as VBA code. 1) Alt-F11 (to enter Visual Basic Editor)2)
Insert Module3) Copy and Paste the above code4) Press Alt-Q to go back to
spreadsheet5) Alt-F8 and select DemoFormulaHope that helps.Regards,Kevin
 
Sorry, bout the formatting...let's try that again...

Sub DemoFormula
Worksheets("Sheet1").Range("A1").Formula = "=$A$4+$A$10"
End Sub

That would be entered as VBA code.

1) Alt-F11 (to enter Visual Basic Editor)
2) Insert Module
3) Copy and Paste the above code
4) Press Alt-Q to go back to spreadsheet
5) Alt-F8 and select DemoFormula

Hope that helps.

Regards,
Kevin


Kevin Stecyk said:
Cecilia,

Yes you can.

Sub DemoFormula
Worksheets("Sheet1").Range("A1").Formula = "=$A$4+$A$10"End SubThat
would be entered as VBA code. 1) Alt-F11 (to enter Visual Basic Editor)2)
Insert Module3) Copy and Paste the above code4) Press Alt-Q to go back to
spreadsheet5) Alt-F8 and select DemoFormulaHope that helps.Regards,Kevin
Click to expand...
 
Cecilia
Basically, anything you can do manually in a worksheet, you can do with
VBA. And you can do much, much more with VBA than you can do manually.
HTH Otto
 
Back
Top