changing formula result to constant value
What's the quickest, easiest way to convert the result of a formula into
a constant? For examply, I used the proper command to change fields of
data to title case. Now I need to do a mail merge, and I want to change
the fields so that the title case data is a value, rather than still
being the formula.
pemily's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7588
View this thread: http://www.excelforum.com/showthread.php?threadid=491857
For a single cell: ...Excel formula bar
Operating System: Mac OS X 10.5 (Leopard)
The formula bar in Excel has migrated part way off the screen to the left so I can neither close it nor move it. How can I get it back onto the screen?
First thing to try: While Excel is running go to System Preferences> Display
& set your display resolution to a higher setting. Switch back to Excel &
see if you can drag the bar back to the middle of the screen, then set your
resolution back to its normal setting.
If that doesn't work post a new message in the Excel group for other
suggestions. Make su...Using worksheet name as reference
I have one master sheet with around 50 rows in it. For each Row there
is corrosponding worksheet. e.g. Row #23 will have corrosponding
worksheet named '23'. I want to populate some data from worksheet 23 in
Row no. 23 in master sheet. How should I refer the sheet 23
automatically using Data 23 in cell in the row ? If type ='23'!B21 I
can get it but I want to automate it so I'm refering to cell instead of
23 which is ='A12'!B21 here it gives error because I'm making formating
Pl. help .
Dynamics GP v9 - Collections Management
Users are unable to use "user defined letters" (Word Documents) for mass
mailings. They are limited to only using predefined letters, or printing each
letter individually for every customer.
Error received when users attempt to use a custom letter:
Unhandled script exception:
Cannot find report "COL_Reminder_UpcomingDue".
This post is a suggestion for Microso...Auto-select combo box entry when only one row
I have 2 combo boxes the second is dependent on the first. When the first is
clicked, I requery the second in the OnClick event. When the requeried combo
box has only one row, I'd like this to be auto selected. How can I do this?
"mscertified" <email@example.com> wrote in message
>I have 2 combo boxes the second is dependent on the first. When the first
> clicked, I requery the second in the OnClick event. When the requeried
> box has only one row, I'd like this to be...Outlook 07 on Vista: 2 Different User Calenders Viewed Together?
My wife and I use Vista on separate user accounts. We're both set up as
administrators. We also are using Outlook 2007 for our own
Is there a way to view the calenders together, as ONE?
Is the only way to do this to set up one user account we're both
Any help greatly appreciated.
ZaveyZipper <das216at_comcast.net> wrote:
> My wife and I use Vista on separate user accounts. We're both set up
> as administrators. We also are using Outlook 2007 for our own
> Is there a way to view the calende...Application-defined or object-defined error
I find myself stumped by an incredibly easy piece of code and one that I
have used before.
I am getting the error:
Run-time error '1004':
Application-defined or object-defined error
I am getting the error when I run the following code:
Private Sub Workbook_Open()
.ScreenUpdating = False
.DisplayAlerts = False
Workbooks("phoneholdtime...proper name conversion
I have a database that has names of people in one field,
in a last name, first name order. (example: Smith, John)
How can i seperate the last and first names from one text
field into two different fields? Or at least have only
the last name. thanks for any help.
>I have a database that has names of people in one field,
>in a last name, first name order. (example: Smith, John)
>How can i seperate the last and first names from one text
>field into two different fields? Or at least have only
>the last name. thanks for any help.
This is air ...Chart title = Worksheet Name?
I have a workbook where every sheet represents a different day. The title
of the sheet is the date e.g. 9-14-06. On each sheet is a chart whose title
is same date as on the tab, but formatted slightly differently: Thursday
<cr> September 14, 2006.
Is there a way to easily link the two so when I update the tab date, the
chart date changes also?
I do hope someone can find a shorter way but here is mine.
Firstly, the name on the tab will not be recognized as text by Excel, so wee
need to get the sheet name into a cell and then extract year, month day
A1 (sheet na...Data Validation Allow List
Is there a way to click on the resulting combo box and have ALL the list
items show up instead of just what seems like the default of about 8--I can
scroll, but would like to just point and choose?
Also, is there a way to change the font of this combo box? The resulting
look like they are about 6 or 8 points.
Any help is appreciated.
Is this the right forum doug?
If you are using a combo box (from the control toolbox) as opposed to a
validation list you can change visible rows but not if you use validation
Debra has a solution here
R...Money 2004 Small Business
Question-- Will Money 2004 Small business support
Schedule F (Farm) expenses?
...runtime error 2465: application-defined or object-defined error
I'm trying to use a button on a main form to change the sort order of a sub-
subform.When I execute the following, I get runtime error 2465: application-
defined or object-defined error. opting to debug, I find the line with
orderbyon highlighted. Anybody see what's wrong?
Private sub timesort_click()
Forms![control]![worklist]![approved].Form.OrderBy = "Forms![control]!
Forms![control]![worklist]![approved].Form.OrderBy0n = True
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/a...CListCtrl Report View Resizing
I have a CListCtrl that I resize according to its parent window's size. I resize the control by calling SetWindowPos with the new size and I modify each column's width to take the new width / the number of columns. Although the columns resize nicely, the control itself never does. Could some one tell me what I'm missing?
I had done it like this.In the parent window onsize i used
x and y are parameters of parent window onsize.
I hope it will help u.
sorry for my english
"Dan" &...Formula help required
I have 3 conditions
score divided into 3 parts 50, 75 and 100 %
If score in cell = > 27 then -3
If score in cell = >26<36 = -2
If score in cell = >18<27 = -1
If score in cell is > 27 shows false
Your conditions are a bit ambigous, shouldn't the first criteria be >=37 ?
Conditions for the formula below:
F48 >=37 result -3
F48 between 26 and 36 result -2
F48 between 18 and 25 result -...Mutual Fund Names and Stock Names displayed on multiple lines
In 2005 Deluxe, Portfolio Manager, Group by Investment Type, the same mutual
fund is incorrectly listed on multiple lines. And, if I move the cursor over
different lines, the names sometime change. The mkt values appear correct,
but the fund names are all messed up.
Is there an update or service pack ready yet to fix this and/or other
Have the same problem with money 2005 canadian version the Symbol,Name,Last
Price and %Change change to the line the cursor was on before all else stay
> In 2005 Deluxe, Portfolio Manage...Defining a variable to = MATCH
Dim thingy As Integer
thingy = "=MATCH(""DiceC"",qperiodagentperformance!A:A,0)"
ActiveCell.Formula = _
"=INDEX(qperiodagentperformance!D" & thingy & ":D13000,MATCH(""Agen
Summary"",qperiodagentperformance!A" & thingy & ":A13000,0))"
my thingy doesnt seem to work..... no comment
Any suggestions on correcting this?
Message posted from http://www.ExcelForum.com
thingy = Application.Match("DiceC",
Sheets("qperiodagentperformance"...Naming a formfield
I am using Word 2003, I have added a formfield with code as shown below,
declared the ffield as a formfield but the code is debugging with object
variable not set for some reason on the '.Name'. I have successfully used
this bit of code in other templates I have created. Can anyone offer me an
alternative or solution please?
Set ffield = _
.Name = "contaminant"
With .Text...Order of Names in E-mail differs from that in Contacts (Outlook 2002)
I'm using Outlook 2002 and my contacts are all in the order of 'Surname,
First Name'. When I open up a new message and click on 'To' to address it
the names are all in the order of 'First Name Surname'. How can I change the
order to 'Surname, First Name'?
Thanks in anticipation. Andrew
Andrew Mawby <firstname.lastname@example.org> typed:
> I'm using Outlook 2002 and my contacts are all in the order of 'Surname,
> First Name'. When I open up a new message and click...how to do self-defined regression in excel?
Hi, I want to do regression ananlysis in excel using a
sigmoid function, which is not offered in the general 6
functions in excel(by adding trendline). How can I do it?
The Analysis ToolPak - VBA addin has a regression function
and probably everything else you want.
Tools > AddIns then checkmark Analysis ToolPak - VBA
Go back to Tools dropdown and it should be listed near the
bottotm of the dropdown.
>Hi, I want to do regression ananlysis in excel using a
>sigmoid function, which is not offered in the general 6
>functions in excel(by a...User-Defined type not defined?
I recently imported all my data into a blank DB now I am getting this error
Dim wrk As Workspace
Is that something to do with me importing into a new DB
Thanks for any help...........Bob
Sub SelAllNone(Optional SelectAll As Boolean = True)
On Error GoTo stoprun
Dim sqlStr As String
Dim wrk As Workspace
Dim db As Database
Set wrk = DBEngine.Workspaces(0)
Set db = CurrentDb
sqlStr = "UPDATE [tblHorseInfo] SET [Worksheet] = " & SelectAll & ";"
db.Execute sqlStr, dbFailOnError
Set wrk = Nothing
Set db = Nothing
...user defined fields 01-12-10
I have created a user defined field "GHINno". Using copied code I can
emumate user defined fields and find "GHINno". I have code the Sets folder
to the "Folder"- "Set MyContact = MyFolder.Folders("Seven Hills Mens Club")".
But I can't figure out how to get to the value(s) in "GHINno", either the
first value or loop through all values. Any help with UserProperty or
Userproperties or whatever would be appriciated.
See http://www.outlookcode.com/article.aspx?ID=38 for info on property
You can use a F...YES or NO formulas
I have a column that has a series of numbers it will always be either 10000
or 10100 , I want it to return a No for 10000 or Yes for 10100 in the field
next to it,
I have tried and I can't seem to make it work, I can do one or the other,
any assistance would be greatly appreciated.
The cells I am using for example are BF20 to BF34 and the answer I want to
go into BG20 to BG34
and copy down
"Alyssa" <Alyssa@discussions.microsoft.com> wrote in message
news...Can't find source of Application-defined or object-defined error!?
I won't post all of the code here because it's too extensive but here's
a watered down version (all variables declarations are not listed):
Dim i as integer
Dim PortName As String
Dim ReviewSht As String
Dim ModelSht As String
Dim HoldingsSht As String
Dim Model As Range
PortName = Right(ActiveSheet.Name, Len(ActiveSheet.Name) - 15)
ReviewSht = "Price Weight - " & PortName
ModelSht = "Model Data - " & PortName
HoldingsSht = "Holdings - " & PortName
Application.ScreenUpdating = False
Range...Range names list via ADO
I'm trying to get the range names list via ADO.Net, but can't get
informations about this :-(
Do you have an idea for me ?
...CRM 4.0 Maximum Attachment file size
How do I increase the maximum attachment file size to more than 8MB?
In the system parameters, when i try a higher limit i get an error message
saying i must enter a number between 0 and 8192.
In CRM 3.0 we currently have a limit of 30MB. We are in the process of
upgrading to CRM 4.0 and I am unable to put the same limit.
Is it possible to put a higher value than 8192?
I ran into the same problem but found the fix. You need to change the
following 2 lines in your web.config file to increase the size beyond 8MB
1. <httpRuntime executionTimeout=&quo...