Formulas do not work in excel.
Formulas have been working but suddenly they will not add or subtract unless
we click on the target cell. This happens in all excel files even in new
Try going to tools-option-calculation and click automatic if it is on manual.
Let me know if it works.
> Formulas have been working but suddenly they will not add or subtract unless
> we click on the target cell. This happens in all excel files even in new
...how can i search for sheet with any part of sheet name
hi every on
i need code for userform of textbox and listbox to search for any
sheet in workbook with any part of that sheet name on i enter on
textbox to populate on listbox all sheets named contain that enterd
text on textbox .
any help appreciated .
This code takes a string and searches the sheet name for it. Set strData to
your textbox value and instead of msgbox, do a listbox.add
Dim strData As String
strData = "Dat"
For i = 1 To ThisWorkbook.Sheets.Count
For j = 1 To Len(ThisWorkbook.Sheets(i).Name) - Len(strData) + 1
If UCase(Mid(ThisWorkbook.Sheets(i).N...Lookup selective from another sheet
Assume I have one sheet as below. How can I create a new sheet and display
only those entrys that are greater than a entered value.
i.e main sheet
on second sheet, if 4 is entered only entrys >4 are shown. i.e
Try something like this:
Your main sheet is A1-b6 and Sheet 2 is A1:B4
"Jim" <Jim Forrest@hotmail.com> wrote in message
> Assume...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <firstname.lastname@example.org> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Linking a Column List to a Row List #2
Thanks for the help, it worked perfectly
Moe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1250
View this thread: http://www.excelforum.com/showthread.php?threadid=27428
...Alternate Row Shading
I'm a newbie who's got a five-column worksheet and about 900 rows, most of
them already typed. Grateful if someone could advise how to shade all of
the rows in an alternate fashion, i.e., light-gray, then dark-gray, etc.
> I'm a newbie who's got a five-column worksheet and about 900 rows,
> most of them already typed. Grateful if someone could advise how to
> shade all of the rows in an alternate fashion, i.e., light-gray, then
When using auto-filtering, how can I "number" how many records are displayed.
Your question has fallen into an Access news group. Try an Excel news group
for a better chance at getting a quick answer.
Microsoft Access MVP
> When using auto-filtering, how can I "number" how many records are displayed.
"Rachel" <Rachel@discussions.microsoft.com> 在郵件
> When using auto-filtering, how can I "number" how many records are
...How To Copy Rows without Work Art
I have some Word Art in say Rows 9-23, I use some Macro code to copy cells
9-23 down to 10 grouped rows below 23, but everytime I run the Macro it also
copies a 'New' Work Art over the existing Art below Row 15. My fear is that
my file size will balloon. My code simply states
How can I copy Rows 9-23 without the WorkArt also (which is 'floating' over
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...empty rows at bottom of worksheet
My worksheet has about 66,000 empty rows at the bottom of the sheet and that
affects my usage of the scrollbar on the right of the screen. Anyone know how
i can get rid of those miscellaneous rows?
If you will turn on the page break preview (piece of paper with a magnifying
glass) which is the icon on the on the Standard Toolbar to the right of the
Printer icon it will show you exactly what is going to print. There are
solid blue lines that the edge of the page, the dashed blue lines are soft
page breaks. Find the solid blue line at the bottom of the spreadsheet and
drag it ...Cannot view owa with subject that contains extended characters
Thanks for any reply.
I use exchange 2003 on a win 2003 server.
When clients access there emails throw owa, messages with extended charcters
is not dislpyed, like swedish åäö. I use ISA as a firewall.
"Micke" <Micke@discussions.microsoft.com> wrote in message
> Thanks for any reply.
> I use exchange 2003 on a win 2003 server.
> When clients access there emails throw owa, messages with extended
> is not dislpyed, like swedish...PROTECTING FORMULAS #2
I have a sheet where when opened, it runs an auto macro to move cell
contents from one
column to another and uses a formula to do some calculations. If I select
the columns I want unlocked, then protect the sheet and try to run the
macro, I get an "run time error 1004 unable to set the numberformat property
of the range class" When I debug the following is highlightd
"Selection.NumberFormat = ";;;" " I was a Lotus user and in Lotus I
could select a range of cells or columns to protect, I'm having a hard time
to get Excel to do the same.
I appreciate th...Automatioc spill over data to a new Excel sheet from Xml source?
I have an XML source file with data for more than 256 columns. Since one
sheet can contain a max of 256 cols, Is there a way to make Excel, create an
additional sheet to keep the excess data? Preferrably using Xml map /
...How to retrieve data which contain "/" in it
I try to pull a data from access with contain a speacial character "/" in it
but what i get is it not return a single data, so how do i wanna retrieve it?
below is statement I use it but it return nothing.
SELECT LDDATA.COR, LDDATA.CON, LDDATA.PCODE, LDDATA.QTY, LDDATA.BOXNO,
LDDATA.CASENO, LDDATA.RSNOS, LDDATA.RSNOE, LDDATA.NOFRS
FROM LDDATA WHERE (((LDDATA.COR)="A11/LC/000002/11/06")) ORDER BY
On Tue, 22 May 2007 21:53:02 -0700, osmanar
>I try to pull a data from access with...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hemail@example.com> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...Worksheet name in cell formula
I asked this question a while ago and got a prompt answer which I thought
was what I wanted but alas its not...
I want to be able to change my worksheet names.....ie: from Sheet 1, Sheet
2, etc etc.....to something more meaningful.....eg Sales, Expenses....etc
etc.... and have these changes reflect on the worksheet.
For example, I might want Sheet 1 Cell A1 to say.....This is the Sales
worksheet (assuming I have renamed it to Sales).
The answer I was given some time back worked.....but it changed the formula
on every worksheet to reflect the name of the last changed sheet.
By this I mean.....insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...Empty rows
When I do Shift+Page Down+End+Arrow Down from the first selected row, it goes
to row 65,536. How do I get it to go to the end of the report (the last
clear your used range first:
"Connie Martin" <Connie Martin@discussions.microsoft.com> schrieb im
> When I do Shift+Page Down+End+Arrow Down from the first selected row,
> to row 65,536. How do I get it to go to the end of the re...Colour numbers within my formulae
I have been playing around with the '&' function, allowing me to mix text
with calculations and cell references.
I have the following at the moment:
="Of the "&TEXT(J954,"�#,0.00")&" made this year, I have managed to save
Which gives me a cell displaying the following:
Of the �0.00 made this year, I have managed to save 0.0%
What I would like to do is show the numbers (�0.00; 0.0%) in the colour
blue. I don't want to add conditional formatting, just apply a colour so
t...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...embed x.s sheet to HTmL page
I have a file called Bonds.xls located on my C drive in a flode
called Support. I want to insert this file to a HTML pae. I trie
embed, object and everything I could find but i cant get it to insert
I am using office and OS wkin200.
Can anybody give me some help? I dont know if I am using tags wrong o
just wrong tags.
Message posted from http://www.ExcelForum.com
Have you tried saving the worksheet in html format? You can incorporate
this html code into the web page.
Jon Peltier, Microsoft Excel MVP
...Excel formula 03-26-10
I need a formula that does the following:
Calculates how old I am when a birth date is entered. The formula needs to
use the calendar days not a fixed number of days per month. The second part
is if the person is more than half way through the year the age needs to
increase by one. For example my birthday is april 14 1973. That make me 36
years old. Because I am more than half way through the year the formula
needs to tell me that I am 37. Any help would be appreciated please remember
it must be calendar days not a fixed number of days per month. Thanks!