Trapping a NO FIND after a find
I use the code below to store a row number to a variable after a find.
I would like to trap a NO FIND if the find is unsuccessfull
Any ideas. FSt1 provided the code below
dim rn as string
dim rng as range
dim therow as long
rn = inputbox("enter something to find")
if rn <> "" then
Set rng = nothing
Set rng = range("A1:IV65536").Find(what:=rn, _
...random numbers in filenames
i noticed that my excel files are being appended by random numbers when i
eg. a file named myfile.xls, when opened will be come myfile2.xls,
is this normal?
That appended number denotes that you have *additional* "windows" open of
If you would go to
You would see that number increase, meaning you have 3 windows open.
You probably can't see them until you go to
And pick a display format (tiled, vertical ...etc.)
This allows you to see different parts of the same sheet,...Missing Tools Bar OE
My Tools Bar is missing all of its info.
New Mail, Send/Receive etc. I do have it checked.
I have the tool bar for Newsgroups.
It has come and gone a couple of times, I think it
came back after a reboot, but it's gone again.
Toolbars disappear from Message Composition windows or the main OE window:
Imperial Beach, CA
"amdx" <email@example.com> wrote in message
news:73b5f$4b9ceb34$18ec6dd7$5051@...Incrementing Mixed text & numbers
Folks I'm designing a spreadsheet to hold log-on numbers for temporary
workers. The format of the numbers is MWI***Z, where *** is a 3-digit
number. Is there any way I can use an increment function to automatically
complete a long list of numbers eg MWI001Z, MWI002Z, without having to type
them all in. I've tried using the fill handle, but it doesn't work on this -
presumably because its a mix of letters and numbers.
Thanks for any help.
well, I'm no guru at this (yet) but I would say in a new worksheet in
column A type in MWI0001, MWI0002...etc then use the f...I can't find my hidden emails
How do I retrieve my hidden email folder. I have windows mail using vista
To see your storage location,
Open Windows Mail,
go to Tools - Options - Advanced - Maintenance - Store Folder
It's normally C:\Users\<yourlogin>\AppData\Local\Microsoft\Windows Mail
\Appdata is normally hidden
Email messages are stored as individual .eml files.
Windows 7 Ultimate
"Hatsoff" <Hatsoff@discussions.microsoft.com> wrote in message
news:2301FECC-9C1B-4051-BECC-E59087654D5E@microsoft.com.....Merging 2 excel sheets with numbers and words
I started with one sheet (using Excel 2003) but took a copy home (on a flash
drive)to work on and added data (both numbers and "X" 's) - using Excel 2007.
I saved the work done at home so Excel 2003 could "read" it. Then, I did
some work on the copy my computer at work (BIG mistake!!)
So, the problem is: I have some data on my flash drive copy which is not on
the work computer sheet, and vice versa. I want to merge the 2 copies - so I
cannot replace either one because data will be lost.
Options??? Way to do this? (It seems like it will be easier to "Co...cannot find database
I have an excel spreadsheet that is supposed to update a access db.
Whenever I try to save the .xls I get an error stating cannot find db.
Even when I open the db with access, I get the error and the db opens
anyway?????? This only happens on 2 out of 20 pc's and I cannot figure
...Numbering bugs when saving Word 2007 as Word 97-2003
Using both Word 2003 and Word 2007 on Windows XP OS
Okay, I've been dealing with this problem for awhile now. but it causes a
lot of extra work. Half our staff use Word 2003 (home workers) and the other
half have upgraded to Word 2007. I use both Word 2003 (telecommuting) and
Word 2007 (office) and I do the finalizing of these files here. We share
large-document files among us, so we save the files as Word 97-2003 so
everyone can access. This results in numbering getting completely out of
whack after you save it and reopne. Also the heading formatting is lost
sometimes (b...Reading File and finding information
Basically i wish to do a search and find function in a file and use th
information to place data in a secondary file with a matching value.
I have 2 excel files that i want to extract some information from.
I have an excel file which contains lots of different values, fro
values 10001 -40001. In the other excel (old csv) files i have th
same numbers with associated text with it. I want to have the fil
containing the data with text attached searched through and the th
matching data copied to the main excel sheet.
The sheet containing the values and associated text may contai
additiona...Insert duplicate rows based on numeric value in column
Is there a way to insert new duplicate rows in an excel worksheet based
on a value in a column? For example I have 2 columns as follows
I want to achieve the following
Lisbon 2...and so on
So I basically want the first column and its value repeated the number
of times specified by the associated value in the Number column. I hope
that makes sense. I hope someone can help as this is driving me nuts and
I a...Find (but not find)
My program takes a name from sheet3 goes to sheet1 to Find the name.
If it cannot find name, how do you do an If/End to Exit Do while or
find out if name has been founf? I have "On Error Resume Next" in
Thanks again for all your help
As ALWAYS, post your code for comments & suggestions.
Microsoft MVP Excel
"Gordon" <firstname.lastname@example.org> wrote in message
> My program takes a name from sheet3 goes to sheet1 to Find the na...Advanced Find doesn't work
After having updated my Office 2000 version with service
release 1a and service pack 3 the Outlook 2000 advanced
find function no longer works. It doesn't deliver any
results and pretends to continue searching forever. Anyone
any ideas about this problem?
Same problem here....except it doesnt seem to keep searching. It will only
find something within the last day or so.
"Steve Kraft" <email@example.com> wrote in message
> After having updated my Office 2000 version with service
> rele...Convert numbers to text
I have a column of numbers that I need to import into a SQL Server. I need
to keep the numbers with the leading zeros (e.g. 0004 instead of 4). If I
enter '0004 into a cell and then import the data into the SQL Server I get
NULL for that cell.
Is it possible to convert the whole column of numbers into text? Is there
another way to fix this problem?
Pre format the column as Text and enter 0004 or
Custom format the column
"Vik" <viktorum@==yahoo.com==> wrote in message
news:eG$X9pHiJ...find efficeincy #2
Hi i need to find the efficeiny of a project
i have 60 minutes availalble
i have a target of 78
if i have no stoppages and produce 78 i am 100%
if i have 30 mins stoppages and produce 39 i am 100%
if i have no stoppages and produce 39 i am 50%
can anyone tell me an easy wy of calculating this
...Same email arriving a number of times
I have a problem whereby the same email has been delievered a number of
times, after tracking the message using Message Tracking Centre in
Exchange System Manager, the following happens:
2/24/2003 10:06 PM SMTP: Message Submitted to Advanced
2/24/2003 10:06 PM SMTP: Started Message Submission to
2/24/2003 10:06 PM SMTP: Message Submitted to
2/24/2003 10:06 PM SMTP: Message Categorized for Queing
2/24/2003 10:06 PM SMTP: Message queued for local
2/24/2003...Finding no of elements in the pointers
I have one problem...
My problem is how to determine the size of the pointer. (No of
i have the string pointer... after some process the pointer contains
some no of string elements. so now i want to know how many strings
reside on the pointer...
// now pstrArray contains some no of string elements.
-> now how to know the no of elements in the pointer?
for normal array we can find this by using
sizeof(array variable)/sizeof(type of array)
but for this pointer i don't know how to find....
thanks in advance,
...Finding data in grouped sheets
When using the 'find' option whilst workbook pages are grouped together I am getting data from the last page first, then the last but one etc. Can anyone tell me whether it is possible to change this so that it finds the data in the first possible page, ie it looks at page 3 before page 4 etc?
What I am trying to do is set up a spreadsheet which finds the first 'vacancy' in a childrens nursery. As I have set it up at the moment it is finding the last vacancy first!
All help greatly received! Thanks in advance.
This may not quite fit, but you may find it very us...Problem with CEdit- Number style
you can see string can be pasted but cant type in a NUMBER( only) style
how can i protect pasting of string into a number only editbox
open the properties dialog associated with the edit
control. Click on the Styles tab. Click the check box
If you use this, keep in mind that it will only allow
whole, positive numbers. You can't enter a minus sign or
a decimal point.
> you can see string can be pasted but cant type in a
NUMBER( only) s...If Missing #, Show Letter on multiple sheets
Stumped on how to solve this. What I'm trying to do is list what
alpha-characters are missing by detecting if a number is present. All of the
worksheets are exactly the same except for the alpha character they
What I need is an algorithm which will detech what is missing from each
sheet. I have a # to identify if a alpha is missing, but I need a way to
For example, assume there are three worksheets: wks1, wks2, and wks3. If
cell B15 on wks1 has 1, wks2 cell B15 has 2, and wks3 cell B15 has 3 I want
the algorithm to return "". However, ...Find old categories
I merged some categories and when I tried to undo the
merge - it removed all the categories and put everything
under Categories: (none)
How can I find out what categories I had these under
After re-installing Windows 7 Ultimate on my laptop and opening WLM all my
old emails are missing All the accounts are there and new messages are
coming in find. Please help me find those old messages (files).
Have you performed a search for *.eml files ?
Did you install Windows 7 to a different drive/partition, on top of the old, repair install, wipe drive-clean install etc ???
"gary g." <gary g.@discussions.microsoft.com> wrote in message news:12A7D053-A3B0-41EB-8C4E-8693F4181D7C@microsoft.com...
> After re-installing Window...How do I format cells to a specific number of digits?
I am trying to format a column so I can enter 5 digits only. It has between 5
and 7 digit numbers in it right now and I need to delete the remaining ones.
It is about 350 numbers, so it would be a lot of work to go into each cell
and delete the remaning numbers. Is therea way I can format the whole column
to allow 5 digits? The same happened with letters. I had codes in it that
consisted of numbers and letters and the client only wants the first two
letters to remain. How can it be formatted so only 2 characters are allowed
to keep me from having to enter each cell separately?
form...Shapes menu, Actions missing
Using Industrial Control Systems diagram and shapes. Having problems with
changing a Relay contact to show closed contact or show open contact in an
existing document. The shapes menu is missing Actions. If I create a new
diagram, I have this option. For some reason we have several existing
diagrams that this option is unavailable. We were able to do this the last
time they were updated about a year ago. Is there someway to make Actions
available on the Shapes menu. I've tried to add it, but it doesn't show up.
Any suggestions would be appreciated.
"Ellen&q...How do I find cells that being with a blank?
I have a spreadsheet with circa 11,000 rows, approx. 6 columns.
Some of the data MAY contain values that begin with a blank space,
e.g. the cell may look like (ignore quotes)
when it should be
Is there an easy way to change the cell colour to Red for all cells in
a spreadsheet where the first character is blank ?
Thanks in advance for your kind help.
bvinternet's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2...count the number of new lows within a range of cells
Is there a formula or method to count the number of new lows within a
range of cells? For example, the following are in col A rows 5 to 14.
Within this set a new low has been reached 3 times- (96,95,94). What I
would like is a formula or macro that that would produce the results -
3. There are about 9000 rows of data and I am looking for "count of
new lows within the preceding 10 rows" on a rolling basis.
Use this if the 9000 or so rows don't have blanks in them.
In this version you just need to select the first cel...