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 / Thread Starter Last Post Reverse Sort Order Replies Views
with ref to the dialog editor question by DAVE P
A few days ago I posted a question about "dialog editor." (please see below) Perhaps I was asking the wrong question. I'm trying to create a form to input...
July 4th, 2004 06:14 PM
by Dave Peterson Go to last post
1 308
Protecting a worksheet by YS
I am trying to see if there is a way to protect a worksheet, but leave a few cells unprotected (including their formats). I want to be able to change the color...
July 4th, 2004 12:26 PM
by StargateFan Go to last post
2 188
autosave/add-ins by Yogii
I'm not very familiar with Excel but have a couple of files out of necessity. Recently, as I was working on one, there was some kind of error and it had to...
July 4th, 2004 11:52 AM
by Dave Peterson Go to last post
3 120
How to vary column widths by tsac1234
I have a four page worksheet and have managed to make it work with the same column width on all four pages. However, I would like to have different widths on...
July 4th, 2004 10:53 AM
by wiseman Go to last post
5 153
Excel to Lotus by xippy
Is there a way to convert an MS Excel spreadsheet to Lotus? I have saved an Excel file, but it's Read Only for some reason, and doesn't...
July 4th, 2004 09:19 AM
by Andy Wiggins Go to last post
1 171
Athos by Athos
is there a way to write this as a formula? I want each cell (B1:B10) to refer to a fixed cell(A1) in the following way: Cell B1 = $A$1 * n. Where n is a...
(Multi-page thread 1 2)
July 4th, 2004 03:17 AM
by Ragdyer Go to last post
13 234
pop-up/comment of text in chart by acl
Hi I am basically brand new to VBA and excel macros...so please keep that in mind. If the solution lies in either of those, if you would be kind enough to...
July 4th, 2004 12:27 AM
by Jon Peltier Go to last post
2 202
Data validation input message by DT
Can anyone please offer any advice? ..... I am using data validation on a worksheet and would like to resize the message box that appears when the cell is...
July 4th, 2004 12:16 AM
by Dave Peterson Go to last post
8 221
Reduce chart white space by Vinod
When I create a pie chart, a terrible amount of white space exists around the pie. When I insert it into PowerPoint, it takes up way too much room. I can...
July 4th, 2004 12:15 AM
by Jon Peltier Go to last post
2 420
count if by gregork
I need a formula to return text based on that text being in all the cells in a range. I want the formula to ignore blank cells in the range. I have...
July 3rd, 2004 11:23 PM
by RagDyeR Go to last post
6 249
Not Enough System Resources to Display Completely by RamblinWreck
I have a spreadsheet with several drop down menus. Depending upon the screen resolution and/or Percent Zoom, I may get a "Not Enough System Resources to...
July 3rd, 2004 11:00 PM
by David McRitchie Go to last post
2 2,116
Using formulae to display pictures.... by matt_123
Hopefully there is somebody that can help me with this predicament. I regularly compile quizzes on excel which get sent out & are now viewed as far afield as...
July 3rd, 2004 10:32 PM
by AlfD Go to last post
2 351
Work menu in Excel? by billlake
~× wrote: *Very handy feature in Word. It's a menu where you can add the documents you work most frequently with. Much better than the Recent Files...
(Multi-page thread 1 2)
July 3rd, 2004 10:15 PM
by Andy Go to last post
13 678
Matching by gary
a1..e711 contains data in this format: Part-nbr Date Amount 008101815-8 03/12/2001 751.72 008101816-9 03/12/2001 514.50 008101817-0 03/12/2001 ...
July 3rd, 2004 08:28 PM
by Alan Beban Go to last post
2 158
Auto refresh of Pivot Table by K. Georgiadis
I found the following code on C. Pearson's website: Sub Auto_Open() Application.OnSheetActivate = "UpdateIt" End Sub Sub UpdateIt() Dim iP As...
July 3rd, 2004 06:40 PM
by K. Georgiadis Go to last post
2 112
AutoFilter not an Option by Jeremy
I have a large spreadsheet with multiple columns of data. Each column has a label and no column is left entirely blank. When I go to the Data:Filter menu the...
July 3rd, 2004 04:41 PM
by Jeremy Go to last post
3 139
filter out all the #n/a... by sokevin
I have done a vlookup in col(b), col(c) and col(d) i want to summarise column b,c,d in column E e.g if col b2 = #na, c2=#na, d2=300 then i want e2=300 if...
July 3rd, 2004 03:04 PM
by sokevin Go to last post
2 160
Hi! Urgent pls: Protecting sheets so macros/buttons still work? by StargateFanFromWork
Sub YourMacro() ThisWorkbook.Worksheets("Sheet1).Unprotect("YourPassword") 'your code ThisWorkbook.Worksheets("Sheet1).Protect("YourPassword") End...
July 3rd, 2004 02:25 PM
by StargateFan Go to last post
7 913
date and sending message by rpahl
I am trying to create a macro that sends a specific number to a specific cell on a certain day. "If the first day of the month, then send 75 to cell A2 If the...
July 3rd, 2004 01:59 PM
by Norman Harker Go to last post
2 145
Any ways to do something similar to Access Switch() function... by Tripp Knightly
In Excel, instead of doing a bunch of nested ifs for conditional logic, are there any ways to do it w/ something more elegant like the Switch() function in...
July 3rd, 2004 10:09 AM
by Bob Phillips Go to last post
1 156
Post New Thread


Display Options
Showing threads 138641 to 138660 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 08:56 PM.


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