A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
"Replace With" option by Joey
Hi all I would like to amend a column with phone numbers and change only the first two characters to a "0" Most of the numbers look like this; 44131 555...
July 2nd, 2004 04:47 PM
by Don Guillett Go to last post
2 152
"Runtime Error: Subscript Out of Range" by bludovico
ChDir "L:\My Documents\AirCanada" Workbooks.Open Filename:="L:\My Documents\AirCanada\ACA...
October 1st, 2004 11:31 PM
by Dave Peterson Go to last post
1 185
"Runtime Error: Subscript Out of Range" by bludovico
But it opens the workbook first, copies, THEN gives me the...
October 1st, 2004 02:30 PM
by Bob Phillips Go to last post
1 157
"Runtime Error: Subscript Out of Range" by bludovico
What the heck does this mean? If you hadn't guessed, I'm new to macros. I'm getting this message when I try to run one of mine. THe macro opens another...
October 1st, 2004 01:58 PM
by Bob Phillips Go to last post
1 268
"Save As" folder -- can I default this to the same folder as origi by Mike
When I open up an Excel file using Windows Explorer, I sometimes want to use "Save As" to change the name of the file (eg. new month extension, version...
June 11th, 2005 12:06 AM
by Dave Peterson Go to last post
1 88
"Save changes" question. by Paul
Why do I get a message asking me if I want to save the changes made to the spreadsheet when I didn't do a thing to it? I merely opened it up, looked at data...
June 28th, 2004 10:17 PM
by Ron de Bruin Go to last post
1 191
"Search" Function with answer prepared by Biff for Brantty on 01/0 by Frances
Dear All, I found the following beautiful formula from one question raised by Mr Brantty on 01/08/2005 and the answer is prepared by Mr...
August 19th, 2005 05:46 AM
by Frances Go to last post
3 154
"Send to Mail Recipient" icon not working by Lynde
As you know, in Excel you there is an icon on the Toolbar for "Send to Mail Recipient". For some reason, my icon does not appear. When I select Tools...
June 23rd, 2005 04:17 PM
by Ron de Bruin Go to last post
7 249
"Show All" in Excel by PokerPaul
Is there a "Show All" or something similar in Excel like there is in Word? I am having trouble with hidden text (spaces) in the "COUNTA" function.
September 14th, 2004 01:37 AM
by Gord Dibben Go to last post
1 88
"solver" by tb
need to add in solver, but no longer have cd. any suggestions on how I can add this feature without a cd?
September 12th, 2005 01:19 AM
by Mike Middleton Go to last post
1 81
"sort and top 10" is greyed out on the pivot table tool bar. by [email protected]
"sort and top 10" is greyed out on the pivot table tool bar, i.e. it is not available. This is excel 2003 on windows xp-pro with sp2. It is an HP laptop, but...
November 1st, 2004 12:33 AM
by Debra Dalgleish Go to last post
4 200
"Sum of" in column heading in pivot table by Gary Rowe
When I move a column titled January into a column area of a pivottable the title says "sum of January". I cannot change it to "January" without an error...
October 19th, 2004 05:24 PM
by Myrna Larson Go to last post
1 133
"Super Excel" by Arnab Bose
I don't think Excel actually stores all the cell properties in a huge 256x65536 array... otherwise it would take a looot of time to execute some of the...
July 14th, 2004 07:28 PM
by hgrove Go to last post
2 293
"to many line continuation" by an
Hello! To prevent the message: "to many line continuation" Is possible to change next: If = "XXX" Then .Visible = False .Visible = False
October 20th, 2004 03:28 PM
by Myrna Larson Go to last post
1 105
"Too many different cell formats" is preventing file from opening by Jed
An Excel 2000 workbook saved successfully but when attempting to open it again I receive the message, "Too many different cell formats." I have since learned...
September 30th, 2005 09:40 PM
by Gord Dibben Go to last post
1 122
"Too many different cell formats" when opening file????? by R Torbert
How do I recover my file? When I try to open, I get, "Too many different cell formats".
September 20th, 2004 02:34 PM
by icestationzbra Go to last post
1 241
"Transmitting" results by Prospero
Is there a way to write a formula that "sends" its result to another cell. For example: Cell A1 contains a balance, £50 Cell B1 contains a deposit, £50 Cell...
September 19th, 2004 04:34 AM
by Myrna Larson Go to last post
1 93
"Unable to read file"message in Word & Excel by SPRINTSF
My PC has suddenly started displaying the above message whenever I attempt to open Word or Excel files on my hard disc. My files are not corrupted as I get the...
August 20th, 2005 01:23 PM
by SPRINTSF Go to last post
2 100
"unexpected file lock by . " error by MCM1009
I have an excel spreadsheet that is shared and accessed by 5 computers. Only one person at a time can make changes. However, periodically I am getting...
August 25th, 2005 12:12 AM
by MCM1009 Go to last post
0 99
"update link" image distorted by luisp
ok, so I do a "edit\special paste\paste link\Microsoft excel Worksheet object" from a XLS spread sheet onto a PPT page and the image (that gets paste) comes...
August 10th, 2004 05:23 PM
by luisp Go to last post
0 453
Post New Thread


Display Options
Showing threads 101 to 120 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.