Formula to VBA code

**Saky** · 11-30-2010, 10:54 AM

Friends,

I am just using the below ROUND function to avoid the decimals in my excel.
=ROUND((((S4/X4)/3600)/9),0)

Can anyone help me to write the same formula in VBA coding.

Thanks,
Saky

**royUK** · 11-30-2010, 11:07 AM

Why do you want it in VBA, how will you use it?

**Saky** · 11-30-2010, 11:11 AM

Originally Posted by royUK

Why do you want it in VBA, how will you use it?

Roy,

I am just having a try in converting all the simple formulas to VBA code. For simple multiplication i have converted to a VBA code like

Please Login or Register  to view this content.

So as the same way i need to convert the formula into code...Is that can be done using VBA.

**royUK** · 11-30-2010, 11:15 AM

Why covert formulas to VBA, they will be more efficient as formulas

**Saky** · 11-30-2010, 11:19 AM

Pasting down the formulas more than 1000 cells makes the excel very untidy and once the formula is deleted by mistake then that particular cell will not work...so to avoid such cases i want every formulas to work at the backend.

So that is the reason i am trying to convert it into VBA codes..

**royUK** · 11-30-2010, 01:28 PM

Have you not heard of Sheet protection?

Formulas will autofill if your data is in a proper table format & your excel settings are correct

Tools -> Options ->Edit-> "extend data range formats & formulas.

Or as you are using Excel 2003 set your data as a List,

Data-> List -> create List