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, _
...Rich Text Zooming
Does anyone know how when you open a rich text email you
can zoom in and out....normal zoom is 100%. does anyone
know where to change that or how it gets changed to 150%
and if so how do i change it back to 100%????
...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.....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...Carriage return in text box.
Greetings all. I have a form with the record source being a view from SQL
Server. There is a notes field with notes separated by a carriage return.
The access form field only displays the little square box between the notes
representing the carriage return. However, if I open the SQL Server view in
Excel, and format the column as wrap text, the notes do indeed display in the
desired format, which is to have one note per line in the field. Is there a
way to get an Access 2003 text box to display the carriage returns? In the
text, the notes are displayed like this, and let the bracke...Concatenating Date Field with Text Field
I am trying to concatenate a date value ex. 07/07/2003
with text ex. Job 1 Finished. When I use the concatenate
function it changes the date to the numerical value.
Is there any way I can concatenate a date to text and keep
the date value? I want my new field to look like
"07/07/2003 Job 1 Finished" not "37809 Job 1 Finished".
The reason I want to do this is that I ran out of
resources in an Excel pivot (too many rows or columns. I
can get around that by combining a couple of my fields
together. I can do this before I bring my data into Excel
but would like t...about converting numbers to text.
how can i convert a number to text number:
example:if we write (1000) or any number in any cell ,itwill be converted to
(one thousand) automatically.
Microsoft MVP - Excel
"Ahmad Al-Nahar" <AhmadAlNahar@discussions.microsoft.com> wrote in message
> how can i convert a number to text number:
> example:if we write (1000) or any number in any cell ,it...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
...overlay text in two different colours
I want to overlay two words in different colours, but when I overlap the text
boxes, the back text box drops some of its text. How do I combine the two
words? I am using microsoft Publisher
Select the text box, click the dog icon on the picture toolbar, click "none."
Mary Sauer MSFT MVP
"In Trouble" <In Trouble@discussions.microsoft.com> wrote in message
>I want to overlay two words in different colours, but when I ov...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...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...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
...Cell displays ################# instead of the text
I have run into an issue that when the text in the cell is greater than a
certain number of characters, it is displayed as "#####################". If
I change the cell type to "General" instead of "Text" then it displays fine.
How can I fix this so that the type can be "Text" and still display
Try changing the cell's format from Text to General (or anything but text).
> I have run into an issue that when the text in the cell is greater than a
> certain number of character...Importing text more than 65536 having delimiter functions
Would like to import large text files over 65536 lines onto multiple worksheets with delimiting, pls help
this KB article describes a macro which splits the textfile into
Though written for Excel 95, changes for Excel 97+ are noted
> Would like to import large text files over 65536 lines onto multiple
> worksheets with delimiting, pls help
here's some code from Bernie Deitrick that I use sometimes (though I
rather would split the CSV files in a text editor)
...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...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,
...Prevent user input, if adjacent cell text is identical
My worksheet has cells that contain text - Such as 'INF', 'STO', and
Some of these cells are merged into as many as 9 cells (vertically).
I am trying to prevent the same text being input into the adjacent
single or merged cell (which is offset to the right by ONE cell).
So, if a merged cell comprises of ("D5:D10") and contains the text
I want to prevent the user from entering 'STO' in ("E5:E10") etc...
The cells can contain other text, but i want to prevent only 'INF',
'STO', and '...Multiple Text Colors in Same Cell
I am wondering if there is a way to format a cell so that multiple
colors can be assigned to different text within the cell.
I am trying to construct a simple in-cell bar chart representing the
distribution of data across different categories, and want to be able
to distinguish across the different categories using colors.
For instance, this would create a two category bar chart, but I have
no way to distinguish between the first category and the second
Is there any function (e.g. COLOR() ) that would be able to do the
=COLOR(REP...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 converting Text to Number
I am attempting to convert a text field into a long integer.
I have two fields in my table.
Field1 (Value COCurr): Text field containing string numbers with
commas, decimals, and trailing negative signs
Field2 (Cost): Long integer field containing nothing.
I am trying to run an update query, that looks at the string in field
1, determines whether it has a trailing negative sign or not, and then
attempts to convert it into a number, using the cLng conversion
However, when I try to execute this update query, I get no value in
Field2. It's as if I've done nothing. What am I ...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
...Max Text for CEdit ?
I tried pasting a lot of characters into a CEdit but it got truncated and I
couldn't type anything else in. It wasn't a huge amount of characters, just
source from a web page that can easily be viewed in Notepad.
What's going on ? Can I fix it ?
"Robert A." wrote:
> Hi guys,
> I tried pasting a lot of characters into a CEdit but it got truncated and I
> couldn't type anything else in. It wasn't a huge amount of characters, just
> source from a web page that can easily be viewed in Notepad.
> ...Separating text into new columns
Hi, I am having a problem splitting my delimited text file into ne
columns. What I have to do is take several survey results (all in
long string of text) and give each survey its own column so I ca
analyize it. So what I need to do is, at the end of the first survey
have some sort of a column break or something to that effect so th
next set of data places itself in a new column. Here is a smal
sample of what the data looks like:
9.)|Infrastructure|ACCEPTED|Type your comments here.|
10.)|Infrastructure|ACCEPTED|Type your comments here.|
Date: Wed, 03 Dec 2003 12:16:32 -0500 (EST)
In th...How to name a sheet from text in a cell in another sheet ?
I am very much a novice with using Excel, I'd prefer to be doing this
in Access as that's what the data's aimed at in the long run, but the
db I'm being forced to use is not mine and I can't work that out
either - also work don't support Access so I can't use that to do the
data transfer I'm being asked to do... oh why did I say I'd do this :(
Down to the true business...
I have created a workbook and am trying to name the sheets from cells
in another sheet - all within the same workbook.
I have been digging about the net and everything I've found tha...