How would i search a range of a whole column instead of specific cells
Message posted from http://www.ExcelForum.com/
are a few ways.
"Zygoid <" wrote:
> How would i search a range of a whole column instead of specific cells
> like .Range("a1:a300")?
> Message posted from http://www.ExcelForum.com/
I was trying .Column(1)
i see i neede an "s" in there
Thanks a...Need help with Excel Form & ComboBox Tutorial
I have followed instructions... my code on the form is below but it won't
run... I've marked the error...
Can anybody give me any help with this?
Code is below--------------
Private Sub cmdBtnSubmit_Click()
shReport.Range("C4").Value = cbxCity.Value
cbxCity.Value = "Select a City"
Private Sub cmdCityCancel_Click()
cbxCity.Value = "Select a City"
Private Sub UserForm_Activate()
shParameterst.Activate '<-----Run Time Error 424 - Object Required...Publisher 2007 -how to view all pages in bottom row of taskbar
I've upgraded from 2003, and now the pages of my webpage listed on the bottom
of the Publisher window are all missing (my website pub. document contains 10
pages, which were visible as number rows at the bottom underneath the
document within the publisher taskbar frame). I cannot select a page any
more. How can I get this page row back?
Thank you in advance for your replies.
> I've upgraded from 2003, and now the pages of my webpage listed on
> the bottom of the Publisher window are all missing (my website pub.
> document contains 10 pages, which were ..."Do you want to save" when Excel OPENS
I understand about the "Do you want to save" message when you close
Excel, even if you didn't make any changes: Excel doesn't distinguish
between real changes and the recalculation of volatile functions.
But at work we've had a user claim that he gets the message when he
OPENS Excel when our add-in is checked (having been checked when
Excel was open before). Specifically, it asks "Do you want to save
changes to Sheet 2?" I'm sure it's not our add-in as such, since no
one has ever report this before. But it may be some interaction
between our add-...Excel Time Problem
I exported a file from a telephone switch reporting system as a "tab
separated text" file, because when I export the data in Excel I have to
deal with merged cells and other formatting problems.
I have a couple of columns that have time values like 160:02:05 for
logged in time, and 34:16:46 as the waiting dime� Both are time
�DURATIONS� or time in a state.
I used the Format, Cell, custom and [ss] to get the duration value to
seconds, and I get 123406 and 576125 respectively.
I then use these numbers in a calculation typically like 1338 / (576125
- 123406) and I get 219 as the an...Excel 2000: File >> New menu command causes application crash
This is occurring on only one machine on a network!
After saving an emailed Excel template to a standard network location
for Microsoft templates, when selecting File >> New this installation
of Excel 2000 crashes ("Excel not responding" on Close program
dialog). On other machines there is no problem.
Have "repaired" Microsoft Office using that option from the
installation CD-ROM, have removed Excel from Office installation,
rebooted and reinstalled Excel. No change on the problem behaviour.
Everything else appears to be working just fine in this copy of Excel.
We ...excel #76
i have two different spreadsheets containing two columns,
column A contains reference numbers (both sheets will have
the same refernces) column B will contain the amounts
which may differ on each sheet.
i need to run a compare program to identify all amounts
that differ between the spreadsheets for the same refernce
reference no amount
reference no amount
how can i find out the amounts and refernces...EXCEL.exe has generated errors
For an knowned reason, the following message
recently started to display when clicking on
EXCEL on an Windows 2000 system.
EXCEL.exe has generated errors and
will be closed by Windows. You will
needed to restart the program. An
error log is being created.
Attempts have been made to repair, deinstall
and reinstall Office 2000. However, the above
message still displays with trying to bring
Can anyone help?
This WebPage by Chip Pearson provides a good place to troubleshoot.
--...Excel 2007 dates and conditional formats
Can anyone please tell me why I can not use a conditional format (<>=)
to identify if a date is greater or smaller then another. Everytime I
try it, Excel does it right in the first column but misses by 2 days
in all following. It also appears to have problems with the years.
Date of propposed compleation of a task is 10/10/07; if the date of
actual completion is 10/10/07 or sooner, turn GREEN. If the date of
completion is 10/11/07 or older, turn RED.
Can anyone help??
First thing to check:
What does 10/11/07 mean?
November 10 1907?
November 10 2007?
O...Only 1 taskbar button when i open 2 excel documents
Hi all. When i open 2 excel documents i have only 1 taskbar button on the
taskbar even though i did not choose the option to group similar taskbar
buttons under taskbar properties. Hence when i want to switch between the 2
documents i need to go to window and select them. Hence how do i solve this
so that i can have 2 taskbar buttons of the excel documents on the taskbar?
Thks in advance.
Tools>Options>View, check Windows In taskbar
"inenewbl" <email@example.com> wrote in message
news:6F715432-2EB2-47AC-B737-56D63F37537A@mi...how do i create a quiz using excel?
hey guys...i badly need to make a quiz using excel,,,i got no clue how to do
the quiz will be a simple one, no drop downs and should display the scores
after the quiz is taken....
What type of quiz are you looking to create?
What format are the answers? Numbers? Text?
1. Add questions
*What is 2 x 2?*
2. Assign cells for the user to insert their answers. (format cells as
3. Either in hidden cells, or on a seperate sheet, put the correct
4. Assign a point value for each correct answer (can be different for
...Creating a new document from a multiple paged Excel document
Can I save only one page of an existing Excel multiple page document? If so,
how? Thanks to anyone that can take the time to answer/instruct.
Right-click the sheet tab that you want, and hit Move or Copy. Choose
"Create a copy" and then, from the dropdown, choose "new book".
**** Hope it helps! ****
Excel VBA Certification Coming Soon!
"Lisa" <Lisa@discussions.microsoft.com> wrote in message
> Can I save only one page of...What does the "E" in 5E
I am used MS EXCEL to perform a scatter plot. When the information was graph,
Excel provided me with the formula 5E - 71e^0.085x. What does the "E" in 5E
The E is the way Excel represents 10 to the power. So 1.2E3 is 1.2X10^3 or
1200 and 1.2E-3 is 1.2 x 10^-3 or 0.0012.
remove CAPS in email address
"College student" <College firstname.lastname@example.org> wrote in
>I am used MS EXCEL to perform a scatte...HQ Client and invalid store id\connection issue
Have client with four stores. Running RMS V 2.0.
New store is number 4. Have been able to establish connection to HQ but get
this message on the log:
HQ message contains an invalid store\id connection passowrd.
Although the message is quite clear. Where exactly should we be making the
Thank you veruy much.
In HQ Manager, Admin/Stores
Open properties for Store 4 ( I believe you need to be in Maintenence
Mode to do this)
Go to connection Schedule Tab - near the bottom of the tab you can enter
a password - this is unique to each store.
In HQ Client, File/Configurat...Excel 2007 exits without asking if I want to save
I just started using Excel 2007 recently. I notice it exits when I keys in
Alt-F4, without confirming if I want to save, even if I had made changes to
Is there an option which I can set and make Excel 2007 verify if the user,
wants to save before exiting? This is the default in earlier Excel versions.
Thanks for help.
have you recently run a macro in which you forgot to turn on
Application.DisplayAlerts =3D True?
On Nov 24, 5:25=A0am, ch <c...@discussions.microsoft.com> wrote:
> Hi All,
> I just started using Excel 200...Scrolling in Excel
My spreadsheet has a 'frozen' row at the top containing column headers, when
I scroll down through my rows below, excel scrolls down 3 rows at a time. Now
because my data in the rows below is in sections (1 section contains 5 rows)
sometimes I end up viewing 2 different sections (half of one and half of the
one below) at the same time.
Is there anyway you can instruct excel to only jump down so many lines when
you scroll down?
Change the mouse wheel settings in the Control Panel of the operating
system you use.
Bensum wrote...excel opens under task bar
I find that excel always opens under the taskbar.
is there some way to 'reset' the opening position to the screen
dimensions + taskbar size so it opens below ?
it seems to do this on XP pro and 98 SE from time to time.
...Deserialization issues, handling integer properties correctly?
I'm running into an issue when I'm deserializing an xml file into my =
custom object. This issues revolve around integer properties (though =
I'm sure others would apply). I have to account for my xml response to =
be empty (<myintegerfield />), if I simply use one property, I get =
errors that my "Input field not in correct format" when I deserialize. =
I've come up with a fix, but I'm not sure if it is the best path. =
Basically I'm defining two properties, one that the XmlSerializer uses, =
and one that I actually interface from with exter...Pocket Excel
I have a reasonably complicated excel quoting document
that contains various formulae. Is there anyway I can
check to see if it will work on Excel Pocket (PPC 2003)
before I go out and buy a PDA. This will be it's primary
Is there some kind of emulator or reduced down version of
Excel I can use?
The PocketPC 2003 SDK is available to download from MS, I'm not sure, but I
was told (by someone I can't remember), that it may have the PPC2003
emulator in it. If so, you should be able to use that. You may also need
to download ActiveSync 3.7 to be able to upload...Copy and paste from Excel to GridView
is it possible to copy and paste values taken from an Excel spreedsheet into
the grid of a GridView in a ASP.NET page?
On May 21, 4:29=A0pm, Luigi <Lu...@discussions.microsoft.com> wrote:
> is it possible to copy and paste values taken from an Excel spreedsheet i=
> the grid of a GridView in a ASP.NET page?
You mean from a single cell or entire table?
The standard gridview control is a data-bound control for rendering
data. It has no paste function. To copy and paste values from Excel
you can use a separated textbox...business contact manager will not import ACT! 2007
Just upgraded, but my new version of ACT! 2007 will not work. I tried
exporting to CSV but mapping was off.
...XML and Excel
I am not familiar with Excel 2003's XML capabilities and looking for more information. Is there a book or website somewhere that will provide some introductory materials on this subject? I am particularly interested in Excel's exporting and importing capabilities of XML files.
Thanks in advance,
There's information on the Microsoft site, for example:
> I am not familiar with Excel 2003's XML capabilities and lookin...Bug in excel fundamantal add-function
Where can I report a bug in excel? OK I try this group.
A1 = -621,2
A2 = 2
A3 = 1
A4 = -540,2
A5 = 175
A6 = 986,4
A7 = SUM(A1:A6)
A7 must be 3 - but try to have 13 decimals...!!! is this a BUG? I think
Using Danish XP and danish 2002 SP3
No, it's not a bug. It's a "feature" of XL using IEEE double precision
floating point math. Most numbers can't be exactly represented in a
finite number of binary digits, just as 1/3 can't be exactly represented
by a finite number of decimal digits.
You can use ROUND() to round to zero if it's necessary.
...print multiple attachments outlook 2007
How do I print multiple attachments to an email in outlook 2007 without
selecting each one individually?
File-> Print...-> select option: Print attached files
This will of course print the message itself as well.
In order to print only the attachments or a selection of your attachments in
one go, you'll need a printing add-in. Some are listed here;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
If (for example ) I create an excel doc like in the forward example and
print it everything is O.K.
Example (4 column * 4 Rows):
aaa bbb ccc ddd
eee fff ggg hhh
iii jjj kkk lll
mmm nnn ooo ppp
But when I add border to that data it add also shadow to some of the data
(to the aaa bbb ccc ddd elements). How can I avoid it ??? all I want id the
border and not the sadow !!!
I'v Reinstall SW and its Ok
"BoazBoaz" <email@example.com> wrote in message
> If (for example ) I create an excel d...