Incert a photo into a cell based on info in another cell
I need to insert a photo into a cell (a cell that has been merged btw)
based on the information in a cell (i.e. A1). This cell (A1) uses list
validation and allows one to choose from a list of names. What I want
to do is put a photo into a cell (say B1) from a folder (say
C:\Photos\) based on the name that is selected in A1.
azidrane, have a look here and see if this will do what you want
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Fee...Function is killing performance
Hi - I'm using a custom function in a query and it takes forever - was
hoping someone might have an idea of how to speed things up a bit.
A little more info: the function is relatively simple (4 arguments
that are run through an IF statement to pick a value from another
table (only 12 records). The query is run against a table with 41k
records. The numbers don't seem to big here, and the query takes over
Where & how are you using the IF's?
Sounds like a coding problem to me
<firstname.lastname@example.org> wrote in message
news:1189019241.93425...countif function hassle
Im working on two sheets
On sheet 1, I wish cell e37 to enter the number of times a date is
placed in the column h34:h44. (These dates will be randomly entered
The dates will fall on or between the current day "today()" and a date
enntered in sheet 2, cell N2
Every syntax I try falls over and I keep getting zero values in E37.
Its got to be easy but it escapes me. Any help out there?
dond's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25477
View this t...A Percentile IF function
Hi i was running if there was a percentile IF function or a way to run
something similar to an average if function.
Lets say I have a data set like below
What I want to achieve is to find the percentile of all data points that are
The average if function for this data looks like =AVERAGEIF(D1:D8,"a",E1:E8)
So ideally I want to be able to have a =PERCENTILEIF(D1:D8,"a",E1:E8),
sorting column d is no appropriare as different filters are constantly
applied to this data set.
Potentially I would want to ...Cell formatting behaviour question
I have 2 related cases that I dont understand how to get Excel formatting to
1. If I imported or copied rows of data (numerical) from another file (Word
or Access) into Excel, the data is presented as raw numbers in each cell.
Now I apply a formatting (i.e. I want comma separation for thousands, etc.)
and it will not show up. However, if i then double-click inside a cell (as
if to edit the contents directly), then hit enter the formatting I want
shows up... but only that cell. I have hundreds of rows and I really need to
force excel to display the formatting i want immediately...Is it possible to display the number of characters in a cell
I would like to click on a cell and obtain a character count. Is it possible?
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not IsEmpty(Target.Value) Then
(remove nothere from the email address if mailing direct)
"Paul K." <Pa...How to show where cell was copied from?
Previously excel would show where I copied a cell from, ='EBO 2005'!J37, but
now it only shows the value of the, $3,433.04. Previously this was just a
cut and paste, but something has been changed in excel.
It sounds as though you did a Paste Special>Values as opposed to Paste
Copy and Paste functionality has not altered.
"Jim" <Jim @discussions.microsoft.com> wrote in message
> Previously excel would show where I copied a cell from, ='...Too many different cell formats
Does anyone know a way around this error other than to start over and
I think you have two choices - either clear ranges of cells of their formats
or upgrade to Excel 2007, which has a greater limit on the number of
"Gene" <email@example.com> wrote in message
| Does anyone know a way around this error other than to start over and
...Nested Formula #2
In a table below, I am trying to "Count" the number of time a row
begining with "H" has a number "1" iin it. I believe this has to be a
"Nested" function but I am unsure.
I will repeat this function for the leters A/U/S, and for the number
0/2 as well.
H 1 1 0 2 0
H 2 2 1 0 0
A 1 1 1 1 1
U 0 0
U 2 1 1
H 1 2 1 2 1
A 2 2 2 1 1
U 1 1 1 1 2
try the following for counting all H/1 in your range:
assumption: Your range extends from A1...March 11th Windows Update and VBA (dis)functionality in Access
I've programmed an AccessXP database that makes extensive use of VBA module
code called via Macro in response to form object events. Since yesterday's
Office Security updates (multiple), a particular module function called via
macro has begun to throw Microsoft Visual Basic Run-time error 2427 - You
entered an expression that has no value.
On debug, it jumps to the second in a series of about 6 If/Else statement in
which the [Object].Value is tested for content. The first appears to work
correctly, but commenting out the following 5 items one at a time causes the
func...How to get rid of GETPIVOTDATA function?
while addressing cells in a spredsheet from PivotTable Excel 2007 always
puts GetPivotData functionautomatically instead, like old versions, simply
addressing cells (like =B3 or simillar). It makes my formulas very long and
not possible to understand. I wonder if I can switch off this automatic
functuion and tell Excel to address cells just by they simple address?
Office button/Excel Options/Formulas/2nd section: deselect "Use GetPivotData
"Rafal Hemmerling" <Rafal Hemmerling@discussions.microsoft.com> wrote in
Here's what I've got to do:
Priority Rating 1, 2, or 3
CIA Rating (spread over three columns)
0, 1, 2, or 3 -
can be any combination of
(ex: 011, 111, etc)
Priority Validation ODD or EVEN
I need to count the number of records by country (Country names are located
in column D) where records with the following cond...Need more =if functions
I'm trying to do an if,then function that looks at data in a cell and
compares to 13 different possible results but excel on allows 7 nested IF
functions. Any thougths on how to complete this task?
This is in regards to banking. The function should look at the term (13
different terms) and based on the term should return the appropriate rate.
With that many, I would use a VLOOKUP. To learn how to
use a VLOOKUP, see:
Or, if you're dead set on IFs, you could always
=IF(A1=1,1.3%,"")&IF(A1=2,...Unable to move cell selection using keyboard
For unknown reason, I can't move cell selection using the left,right,up,down
scroll lock key ??
"crapit" <firstname.lastname@example.org> wrote in message
> For unknown reason, I can't move cell selection using the
> left,right,up,down key
...Problem entering the number 9 in a cell
For some reason, and I'd be very interested to know WHAT the reason is, I
cannot select a cell and enter the number 9. If I double-click on the cell
I can enter the number 9, but not just by selecting the cell. If I just
select a cell and press 9 the system beeps at me. What could this be?
Look at the Autocorrect entries.
"TBA" <email@example.com> wrote in message
> For some reason, and I'd be very interested to know WHAT the reason is, I
> cannot select a cell and enter the number 9. If I ...Functions and worksheets, passing arguments to functions?
I just got a book called, Excel for Chemists. But it didnt tell me
something i want to know.
I wonder if someone out there can help me?
Here is the problem, say that i have put some data into a worksheet.
A1 cell = XValues and A2 cell = YValues.
If i have a Function that takes 2 arguments below how do i write code
to pass, XValues, Yvalues to the function Deming?
Function Deming(XValues, Yvalues)
Dim MeanX(), MeanY()
'Get number of cells to use in calculation loop
Ncells = XValues.Count
ReDim MeanX(Ncells / 2), MeanY(Ncells / 2)
N = 0
put code here......do something......Determine a server specific ID
I would like to ask if there is a specific ID for each server or at
least for each instance?
I would like to use it like @@nodeid (which i know from Sybase)
One of these might help you...
Other than that, look into the ServerProperty function for more
-Eric Is...Check for # of Words in Function
Apologies in advance, I am NOT a coder, I am trying to fix VBA someone wrote
for me by 'slogging' through it on my own. Making some decent headway on
easier stuff but I am at an impasse.
He has a function that creates an Acronym out of a Value. However I want to
modify it so it ONLY does it if the # of words in that value > 1. Can anyone
give me a heads up on how to add that here please? It would be most
Private Function GenerateAcronym(ByVal val As String) As String 'Tested OK
Dim str As String, prom As String, ch As String, res As String
...Adding Date Formula
Hello, I have these two monster formulas that I want to add together to get
a grand total of time.
DAY(C9)<DAY(C8))),1,0)&" years, "&MONTH(C9)-MONTH(C8)+IF(AND(MONTH(C9)
I want to add the above with:
=YEAR(C12)-YEAR(C11)-IF(...Multiple sheet references in one function
Sheets 1-4 all list claims but they need to be seperated. The values that
are target...drawing function for simple dll
I am new for C++
I want to create some drawing function and call from VB
so i just try to create dll using VC++6
void _stdcall DrawBox(CDC *Dc, POINT Pt1, POINT Pt2 )
// Dc.MoveTo (Pt1);
// Dc.LineTo (Pt2);
but it give error "CDC is undeclared identifier"
i have include <afxwin.h> also
even it give err
error LNK2005: _DllMain@12 already defined in Test1.obj
what should i have to do
I dont know what you are trying to do this. If you want to repaint, do an
UpdateWindow/InvalidateRect. As far as putting this in a DLL, you will need
to know what type of DLL ...Excel crashez every time i open a worksheet with formulas
I would apreciate your help, thank you.
I have Windows Vista Businees x86, Microsoft Office Basic 2007.
The problem first appeared when i reinstalled everything a few days ago.
The steps i took are the folowing:
Format c: -> Reinstal Vista(internet cabe unpluged) -> install Office ->
start Office - > open worksheet(any worksheet) -> Office crashes
I also tried the folowing:
Format c: -> Reinstal Vista(internet cabe unpluged) -> install SP1 then SP2
-> install Office -> install updates(windows Update) -> all updates
installed-> start Office - > open wo...Change cell value result from "FALSE" to blank or zero
I have the following IF statement written into this cell:
If cells N6, P6, R6 or T6 all have zeros written into them, cell E6 shows
the value "FALSE". How can I have this cell have the value 0 under these
"JG" <JG@discussions.microsoft.com> wrote in message
>I have the following IF statement written into this cell:
...Selecting 1 column left from active Cell
I know this should be so simple, but what would be the code to backstep 1
column from the active cell?
"rob nobel" <robnobel@dodoNOGOOBS.com.auNOGOOBS> wrote in message
> I know this should be so simple, but what would be the code to backstep 1
> column from the active cell?
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Synt...FIND function
I am using the "find" function to locate a particular letter in a cell.
This works fine except when the letter does not exist in the cell.
Displayed in the cell is "#VALUE!" and is not useable.
Is there a way to
=if(find("G",A1,1) = "nothing found",A1,find("G",A1,1))
will return either the string "nothing found" or the position of the first G in
You could also use =isnumber()
=if(isnumber(find(...)),"found it","not f...