| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
writing formula w/ variables
This should be a simple solution but I can't figure it out... Here is
the line of code I'm having issues with - .Formula = "=(((COUNT(b:b)+" & var1 & ")*5)-SUM(b:c))/" & var1 &" Why isn't this working for me? I used the same basic "& _ &" roadmap in the following code with no problem Range("H7").Value = "In " & var1 & " Days:" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Writing a variables value every second to a table | Excel Programming | |||
| help in writing a formula | Excel Worksheet Functions | |||
| writing a formula | Excel Discussion (Misc queries) | |||
| Need help with writing formula please... | Excel Worksheet Functions | |||
| writing cells with variables from vba | Excel Programming | |||
Threaded Mode
