| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULAR INSERTION
Hello, Please can anybody help me with this.
i want to put this formular on cell "E1" (=365/(M3/N3) and i want the formular to apply to FROM "E3:E135". I want the formular to be on E1. Please how can i go about this. God bless you as you take your time to ans this. Thanks. Note: There are Title on E2. i want to be able to edit contents of E3:E135. Thanks one more time and God bless. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULAR INSERTION
Try the below
Range("E3:E135").Formula = cstr(Range("E1")) If this post helps click Yes --------------- Jacob Skaria "Kanmi" wrote: Hello, Please can anybody help me with this. i want to put this formular on cell "E1" (=365/(M3/N3) and i want the formular to apply to FROM "E3:E135". I want the formular to be on E1. Please how can i go about this. God bless you as you take your time to ans this. Thanks. Note: There are Title on E2. i want to be able to edit contents of E3:E135. Thanks one more time and God bless. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULAR INSERTION
Hello Thanks. Where is the formular. i need to use this
formular"(=365/(M3/N3)". Thank you for your time. "Jacob Skaria" wrote: Try the below Range("E3:E135").Formula = cstr(Range("E1")) If this post helps click Yes --------------- Jacob Skaria "Kanmi" wrote: Hello, Please can anybody help me with this. i want to put this formular on cell "E1" (=365/(M3/N3) and i want the formular to apply to FROM "E3:E135". I want the formular to be on E1. Please how can i go about this. God bless you as you take your time to ans this. Thanks. Note: There are Title on E2. i want to be able to edit contents of E3:E135. Thanks one more time and God bless. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULAR INSERTION
Hi Kanmi
Your formula in E1 as mentioned in your post 'In E1(cell formatted as text) =365/(M3/N3) 'Within your code OR from immediate window try Range("E3:E135").Formula = Cstr(Range("E1")) If this post helps click Yes --------------- Jacob Skaria "Kanmi" wrote: Hello Thanks. Where is the formular. i need to use this formular"(=365/(M3/N3)". Thank you for your time. "Jacob Skaria" wrote: Try the below Range("E3:E135").Formula = cstr(Range("E1")) If this post helps click Yes --------------- Jacob Skaria "Kanmi" wrote: Hello, Please can anybody help me with this. i want to put this formular on cell "E1" (=365/(M3/N3) and i want the formular to apply to FROM "E3:E135". I want the formular to be on E1. Please how can i go about this. God bless you as you take your time to ans this. Thanks. Note: There are Title on E2. i want to be able to edit contents of E3:E135. Thanks one more time and God bless. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Insertion | Excel Discussion (Misc queries) | |||
| Row Insertion Problem | New Users to Excel | |||
| Data insertion | Excel Worksheet Functions | |||
| Rows Insertion | Excel Programming | |||
| How to use QueryTable with insertion sql | Excel Programming | |||
Linear Mode
