Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Non text function
I declared both a workbook and range and couldnt get my
formula to calculate non text for both the workbook and range. Thanks in advance ''''''''''''''''''''''''''''''''''Macro''''''''''' ''''''' 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&IDS)" '''This comes out as described above im stumped '''is it an indirect? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Non text function
Try changing
ActiveCell.FormulaR1C1 = "=COUNT(FNAME&IDS)" to ActiveCell.FormulaR1C1 = "=COUNT(IDS)" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Jaime" wrote in message ... I declared both a workbook and range and couldnt get my formula to calculate non text for both the workbook and range. Thanks in advance ''''''''''''''''''''''''''''''''''Macro''''''''''' ''''''' 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&IDS)" '''This comes out as described above im stumped '''is it an indirect? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
Advanced text function (combining text) | Excel Worksheet Functions | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |