Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i declare a formula with prenamed variable
I declared a book a specific name but and gave a range a
specific range. when I write the formula on an opposing workbook to count the amount of spaces it comes up as the formula not the value. If someone could help me out I'd appreciate it. Thanks in advance. Jeff Dim IDS As Range Dim Fname As String Fname = ActiveWorkbook.Name ActiveCell.Offset(0, 7).Select Range(Selection, Selection.End(xlDown)).Name = "IDS" ActiveWindow.ActivateNext ActiveCell.FormulaR1C1 = "=COUNT(FNAME&INS)" '''This comes out as described above im stumped |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i declare a formula with prenamed variable
So am I.
Perhaps if you told us what you wanted to do, that might help. What are you trying to count blanks in. I do not see any correspondence between the code and your description. And there may be information in the subject title that is not included in the question. Make sure that your question does not depend on anything only included in the subject. You might also check Tools, Options, View to make sure that you do not have the formula view checked, and the Calculation tab to make sure that calculation is set to automatic. --- 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 "Jeff" wrote in message ... I declared a book a specific name but and gave a range a specific range. when I write the formula on an opposing workbook to count the amount of spaces it comes up as the formula not the value. If someone could help me out I'd appreciate it. Thanks in advance. Jeff Dim IDS As Range Dim Fname As String Fname = ActiveWorkbook.Name ActiveCell.Offset(0, 7).Select Range(Selection, Selection.End(xlDown)).Name = "IDS" ActiveWindow.ActivateNext ActiveCell.FormulaR1C1 = "=COUNT(FNAME&INS)" '''This comes out as described above im stumped |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declare variables to a code? | Excel Discussion (Misc queries) | |||
Declare Variables in Array | Excel Discussion (Misc queries) | |||
How to declare a dynamic array | Excel Discussion (Misc queries) | |||
Declare Multidimensional Arrays | Excel Programming | |||
how to declare a class module | Excel Programming |