Can you insert a picture into a specific cell?
Or do they only "float" on the page.
They float over the worksheet, but you can adjust the size so that it seems to
fit a cell exactly.
If you insert a picture, you can hold the alt-key down while you move/resize the
picture. When it gets close to the edge of a cell, it'll snap-to that edge.
> Or do they only "float" on the page.
I trying to retrieve values from a table to calculate the 14days average
value of a stock closing price. However, i encounter some problem as stated
beside the code as follows:
'Calculate the average value of a given value.
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim varBookmark As Variant
Dim numAve, numDaysAvg As Double
Dim intA, intB, lngCount As Integer
Set db = CurrentDb
Set rst = db.OpenRecordset("SGX Individual Historical", dbOpenTable)
Do While Not rst.EOF
intA = 1
intB = 0
varBookmark = rst.Bookmark
n...Joining text with a formula in cell #4
just to complete the thread...
I found the answer.
You have to change the format of the cell to custom 0.00"*"
this is the only way it will show only 2 decimal places
Thanks for the hel
Mustard Head's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1630
View this thread: http://www.excelforum.com/showthread.php?threadid=27700
...IsOutLookClient() returns wrong value
IsOutLookClient() returns wrong value when both web client of crm and outlook
client are running on the same workstation
It looks like the same cookie(used for determining what client is running)
is used by the sessions of each client.
Look for "LightClient" in IsOutlookWorkstationClient() in global.js
Oeps...I seem to have made a wrong assumption...
Between the to clients IsOutlookClient() seems to work ok...
But in outlook client the IsOutlookClient() function gives false for
me...after I have opened a page from the Microsoft Crm folder structure...
On another workstation it...changing values of one field based on another
How can I best change the values of one field in a table based on
values of another field of the same table. We have an existing table
of thousands of entries and I would like to use the following logic to
populate a new boolean field.
If field1 = "Done" Then BooleanFieldCompleted = True
I have some Excel VBA experience but limited Access. I dont want to
do this manually! Any assistance appreciated.
In general, you'd use an Update query. However, in this case I don't see why
you'd need such a field.
Why not just create a query with a computed field that returns True...Single click selects multiple cells
When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" butt...Non-VBA way of making custom menus.
Sorry for the new thread but even on Google, the thread isn't showing up.
Well, it was SOOO easy, as I knew it would be. The webpage I quoted in my
message this morning didn't mention the "New Menu" at all!
So, here is the non-VBA way to create a custom menu:
- TOOLS > CUSTOMIZE
- under the categories available choose NEW MENU and then drag the NEW MENU
option under the Commands window up to the menu bar (like D'UH!! <lol>
Wish all those hours spent searching yielded webpages that gave this! <g>)
- THEN one can go back to the MACROS category a few line...Referencing cells across sheets
I've created a workbook with three sheets. The first three
columns of sheet 2 and sheet 3 are referenced to the first
three columns of sheet 1.
What I'd like to do, is set the workbook up so that if I
insert a row before, between or after referenced rows in
sheet one, a row will also be inserted, and referenced, in
the corresponding place on sheets 2 and 3. Does anyone
know how to do this?
Also, if no data is entered into a cell on sheet one, the
value shown in the corresponding cells of sheets '2'
and '3' is '0'. I need those cells to remain bla...Copying Data in a cell in one sheet to a cell in another sheet
I've run into a problem trying to copy data from a cell
in one sheet to another. I have a spreadsheet
called "rating" which contains a number of formula that
calculates a final number. I also have a spreadsheet
called "Final" that copies over the information
from "Rating". In "Final", I'm trying to copy a number
from "Rating" into a particular cell. I put in =Rating!
G89, but it won't work. When I press enter, a window
pops up "Update value:Rating". I press enter again and
in the cell where I want the number ...How to unlock locked cells by MACRO?!
I have locked Sheet and I need to change particular cells. But when my
macro wants to change it => ERROR :/
Is there any way to unprotect these particulary cells by macro and
change them? - after that action, of course, I want to lock them again.
Please help me, Pedro
Just unprotect the sheet, do the work, and reprotect the sheet. Kind of like:
'your code to change stuff
Petr N�me�ek wrote:
> I have locked Sheet and I need to change particular cells. But when m...How to add a button to restore all altered cells original values?
I want to add a reset button to an excel spreadsheet that will restore the
values of all changed cells to the original saved ones.
Any help would be appreciated.
this would require quite some VBA code as you somehow have to store the
original values for example on a separate hidden sheet
"Dawnybros" <Dawnybros@discussions.microsoft.com> schrieb im
> I want to add a reset button to an excel spreadsheet that will
> values of all ...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...How do I convert a concatenated value into a know value
I am trying to get the results of a multiple input table, which get
concatenated, read out as usable values
eg. If the concatenated values are for example *llbbt* , I need this t
be read as Simon, or *lbttd* must result in Fred etc...
I will attact the spreadsheet.
Attachment filename: book3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54116
Message posted from http://www.ExcelForum.com
You are probably better off by describing your problem, most regulars won't
Peo Sjoblo...Value is BLANK
In a form i'm working on i've asked this question before and i'm unable to
locate the replies, but in one cell I have a date to be enter and in the
other cell it takes that date and add 5 days to the date to give me a due
date. But if no date is enter then I want to to remain blank insted giving me
Say that the date is to be entered into A1, then enter this formula into the
Please keep all correspondence within the Group, so all may benefit!
==================...Cell with large amount of data not showing all data
I'm running Excel 97. I have a cell with 358 words (1928 characters with
spaces). Word wrap is on for the cell. Only part of the text is displayed
even though the cell is big enough to show everything. If I make the cell
wider (wider than a page) more of the text shows but not everything. I tried
a new worksheet with the same text and had the same problem. Is this a known
issue with excel? Is there a solution?
Left to its own devices, excel will only show about 1000 characters in a cell.
But you can add some alt-enters (to force a new line within the cell) and see
more s...Null value in form not trapped by beforeupdate event
I have a form in Access 2003 linked to a SQL Server 2005 table. When
I clear the value in a textbox (bound field is varchar and is
required), I want the before update event to run to tell the user the
value cannot be null.
When I press the tab button to move to the next field after clearing
the texbox, the before update event is not triggering and instead I'm
getting the following error:
You tried to assign the Null value to a variable that is not a Variant
data type. (Error 3162)
How can I prevent nulls before and this error from triggering?
I'm trying to code a subquery on a table but to no avail...it's a very simple
table that has Date (short date, just recording the day) and NAV which is a
All I'm wanting to do is have a query that displays the Date, the NAV and the
NAV from the day before - only recording business dates. In other words, the
subquery number I want is the NAV from the record preceeding the current one.
I've got as far as the below, but that just gets the same NAV number as
SELECT tblNAV.Date, tblNAV.NAV, (SELECT LAST(x.NAV) FROM tblNAV as X LEFT
JOIN tblNAV on...copy values generated by conditional formula in one sheet to the other work sheet as values
I have data generated by conditional formulae in work sheet1 in
columns A to J. If the condition is satisfied the cell will display a
realnumber, if the condition doesn't satisfied the cell will display
Now I wanted to copy the cells which have the real numbers in
sheet1 to sheet2 as values(as we do with paste special and paste the
values) Do we have any formula or other method to copy the cells in
sheet1 to sheet2. can anybody helpme out in this issue.
Thanks and Regards
Select your range to copy
edit|goto|special|c...formula to have 0 to 6.5 only in ref to other cell val of 0<=6.5
...y value vs x
In an xy scatter plot one can choose the type of line connecting the data
points (smooth, straight, etc.). Once this is done, Is there a simple way of
determining the y value of graph for a specific x value without doing
successive approximations with 0 shifts. I'd rather not purchase a graphing
program just for this simple task.
You could find an equation that fits the data (see trendline)
Bernard V Liengme
remove caps from email
"ralph" <firstname.lastname@example.org> wrote in message
news:284B39DE-20C6-40CB-AB60-39B...Combo Box initial values question
Does anyone know how to make a combo box show a value when a sheet opens?
Mine are always blank when I open them until I select a value.
Try something like:
Me.ComboBox1.ListIndex = 0
"teepee" <email@example.com> wrote in message
> Does anyone know how to make a combo box show a value when a sheet opens?
> Mine are always blank when I open them until I select a value.
thanks for trying.
says 'invalid use of me keyword.&...How do I print to non A4 paper on an HP 450C Plotter from Publish.
Running Publisher 2003 (fully patched) on a Windows 2000 SP4 (fully patched)
laptop, when I print to a HP 450C Plotter (connected to a SBS 2003 server) I
can only print the top left A4 "Window" of the job. Prior to upgrading to
Office 2003 (running office 2000) there was no probloems in plotting up to a
full A0 job. Does anyone have any idea of what is going on and more
importantly is there a fix or work-around?
Have you asked HP? They have many, many support documents as well as drivers. This
would be a printer problem rather than a Publisher issue.
I'd look for you but ...XML Mapping: Creating a "non-repeating schema element" in VS2005
Question regarding XML mapping in Excel.
XML Mapping in Excel allows you to map "non-repeating schema elements" to an
individual cell while "repeating schema elements" automatically get handled
as an Excel "list".
I want a table(XML/XSD) exported from a VS2005 dataset to be CELL mappable
rather than LIST mappable.
Is there a way to make Excel interpret the native dataset XML/XSD as
Said differently, what makes a schema element "repeating" versus
"non-repeating"? Is it a unique XPATH statement?
If my underlying table has...CRM Error
When a user replies to an CRM email, clicks the "reply" button or the "reply
all" button, clicks in the body of the email message and clicks
"insert template", this error appears.
This does not happen every time, and happens to various users.
Does anyone know why we would get this error?
...changing a cell of 60 files
I've 60 files and another one which summarizes all of them..
I've to put a day in the cell a1 and then I'd like to cut and paste
that day in the cell a1 of the other 60 files without having to change
all of them manually.
I'd like to save and then exit every single file.The files are named
0001 0002 0003..and so on.
I know that this is possible with a macro..but I've got a problem..
It's possible not to have the prompt which asks for updates of the file
everytime I open one of them??
Thanks for the help