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, _
...One link breaks every time I open a workbook...
I have 3 workbooks tied together with links. One is a source only, the other
two push and pull data.
One of the sources, Payroll Master, on opening updates all links fine to the
source only workbook but not
to the third workbook (which is in the parent directory). Every time I open
it it prompts me to show it where the Payroll Entry is. Doesn't matter if I
hit cancel and
do Edit Links, I can change it there, but will still lose it upon closing
(the link appears in the box and looks ok, just won't update...)
Try going Edit->Links. Break the link and re-establish it? That m...Utility to process rules based on message receive times?
Does anyone know of a utility that will check a mailbox and process Outlook
rules based on how long a message has been in an inbox, and/or remained
Yes, there is at least one - Auto-mate.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exch...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.....Adding records with referential integrity
I have a few tables in my database, all 1 to 1 with the master table.
I have a query that gather much of the data into one large
datasheet.The problem is I cannot add records through this query.
I get a message that I need a related record in the child table for it
Am I right in assuming I need to add the record in the master database
first, then the inegrity check will create the record inthe child
databases, and THEN I can add data through my datasheet?
A 1 to 1 relationship is unusual, as there can be only one child record for
each parent record. A search for subclas...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
...multi selection into separate records?
Is it possible, in a data entry form, for a user to select multiple items in
a list control and when he clicks a button to open up a continuous form,
parse the selected items and put those values into a separate records?
for example, the user selects X, Y, Z in the list for a certain field and
pass it to a continuous subform to create 3 separate records as in
into the field. Is this at all possible?
Thanks for your time!
I have a database with over 200 records containing several names with
various times taken recorded against each record.
I want to be able to sort, then select the best perfroming (fastest) and
compile into a report (by name) preferably via Macro.
I can do this manually but it will need doing on a month to month basis so
want to automate, how canI get excel to select the fastest times from a range
and report in another worksheet
You don't give enough detail but if you want the n smallest(fastest) times
from a ranges of times then assuming the ...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...Chart for events per unit of time???
I would like to create a graph that indicates Aircraft Departures per unit of
time at the airport. I have access to flight departure times for every
aircraft so my list of data would be something like:
And so on for a days worth of flights. (Probably 50 or more)
The goal is to graphically show what hours of the day have the most
activity. In my example my chart would indicate the time period around 07:00
in the morning has more departure activity than 12:00 Noon.
Any suggestions on how to proceed?
...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" <email@example.com> 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" <firstname.lastname@example.org> wrote in message
> After having updated my Office 2000 version with service
> rele...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
...Highest temp recorded? Try 1922
Hmmm, I thought the globe was warming?
The highest temperature recorded anywhere on Earth was in Aziziyah, Libya,
in September of 1922 - 136 degrees Fahrenheit.
The highest temperature recorded in the United States was in Death Valley,
Calif., in July of 1913 - 134 degrees Fahrenheit.
(SOURCE: Goddard Space Flight Center)
"Taylor" <email@example.com> wrote in message
> Hmmm, I thought the globe was warming?
> ______________________________...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,
...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...Calculating time #3
If i add time when it reaches 24 hours it starts back at
0. i would like it to contunie adding the hours to get a
format as [h]:mm so that your do not roll over into days.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Mike" <Mlundblade@Avon.org> wrote in message news:firstname.lastname@example.org...
> If i add time when it reaches 24 hours it starts back at
> 0. i would like...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...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
...> LIMITED TIME OFFER!!!
> LIMITED TIME OFFER!!!
PLEASE FIRST COPY THIS OFFER THAN READ.
If You like to have an Marketing-PLAN, which brings you money constantly, so
i have the right choice for you.
Money making combinated with more ENJOY and growing luxurios life,
so you only need to get part at my mail-list.
With ONLY 1 US-Dollar, 1 Euro or 1 BP (British Pound).
How to do???
FAST PAY PER PAYPAL at www.paypal.com
After paying You immediatly get this incredible Marketing-Pl...time ???
If i have a time formatted as 2:55 hrs, how can I convert this to just a
total of minutes, for example 2:55 = 135 minutes?
I assume you mean 175 minutes.
Format>Cells>Custom, in the Type box, enter [m]
Microsoft MVP - Excel
"Metalteck" <Metalteck@discussions.microsoft.com> wrote in message
> If i have a time formatted as 2:55 hrs, how can I convert this to just a
> total of minutes, for example 2:55 = 135 minutes?
Multiply it by 1440 and format the result as a decimal...Time Capture
my organization (a municipality) is in the process of implementing Microsoft
GP 10. We are looking to implement the project accounting module for all of
our regular operations. We are not implementing the payroll side of GP as
the payroll and human resources components do not meet our needs. We have
selected Stargarden as our payroll/HR vendor and now need to review the
integration. We are looking at having time capture carried out in Stargarden
and then feeding the information to project accounting.
Does anybody have any experiences with this sort of situation? Your
comments ...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...find, copy or there about
I am looking for a way to pick certain records out of an excel
database. The string I am looking for can be imbeded in a feild either
at the begining end or middle and neither the string nor the feild are
After I have found the records that match the crieteria I need to
perform certain actions upon them.
An addin would be nice that copies according to crieteria. I vaugly
remember an Excel function that does something like that but cann't
remember exactly which one.
I thank you all
It sounds like data|Filter (either Autofilter or Advanced filter) might work.
Or ...from inventory to reduce stock record
I have a basic stock order form with several items on it. How do I link it
to master inventory on another sheet so that every time stock is taken it
will automatically reduce. Appreciate as a novice I need to learn certain
fuctions. Can anyone just get me started with where to look and the
A function or formula is not going to do what you want, you will need
VBA programming. To get help with this you need to furnish some information
about the layout of your data, both the order form and the inventory sheet.
For the order form, specify...