Cell issues #2

Thank-You so much for your help.  that worked wonderfully :) Always nice
to learn something new.


-- 
mysticray
------------------------------------------------------------------------
mysticray's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5279
View this thread: http://www.excelforum.com/showthread.php?threadid=267278

0
10/7/2004 4:26:01 PM
excel.newusers 15348 articles. 2 followers. Follow

0 Replies
580 Views

Similar Articles

[PageSpeed] 2

Reply:

Similar Artilces:

Charting Stock Trendline #2
Anyone have any ideas? Is it not possible? thank -- pwinter ...

How to combine contents of 2 outlook caledar folders back into onl
Trying to undo archiving of calendar "golfingsailor" <golfingsailor@discussions.microsoft.com> wrote in message news:1447A0BF-070A-4AD5-B991-A9B4074C3C7E@microsoft.com... > Trying to undo archiving of calendar If it's not open already, open the archive PST (File>Open>Outlook Data File). Using either the Calendar or Folder List view of the Navigation Pane, open the calendar in the archive PST. Display that calendar in a table view like By Category or Events. Select all the items in the calendar by pressing Ctrl+A or select the ones you wish to re...

Safe way to check what is in a cell
Hello, I am writing an application that is supposed to parse a spreadsheet file into individual files dependent on what is in the first column. Each block of rows with the same numeric string or number is used to create a new file, i.e. a change iin number signals end of a file. Lines with anything else are to be ignored. For this reason, I need to check the first column for one of the following: 1. A string of numerals, f.ex. "014" 2. A number, f.ex. 610 3. #N/A 4. Blank 5. Anything else So, I need a safe way to tell if I have either 1 or 2, or one of the rest. I have code that ...

Suppres Zero or empty Cell value in a line graph
Hi I'm using Office 2007. I have two charts using data from the same sheet. The second graph is a copy of the first. In the first graph, the empty and zero value cells are not displayed. In the second graph, the zero value cells is displayed (draged to zero) although the option "connect points with line" is checked. The strange thing: if I change the Y-data to another part of the sheet, it is no longer dragged to zero. Even if the cell is empty it's still dragged to zero A formula that returns "" is not an empty cell, it's a formula (or it's a small ...

MOP/SOP LINK #2
Hi, I created a new item and its fulfillment method is Make to Order-Manual. I created a sales order and a mfg order for this item. In GP 8.0, I opened the MOP/SOP Link window, only saw the MO on the right side for this item and the SO didn't show up on the left side. Did I miss any step to link MOP and SOP? What should I do, so the SO will show up in the left side? Thanks. stien Make sure the end date is set correctly, it must be out farther than the requested ship date on the SO (the default is the current date) also make sure you have a SITE ID in, even if you only have one s...

Check box and Command button code #2
This code will change the named range of cells yellow when the check box is checked and the command button is pressed which is what I want it to do, but when you check the check box, it will take the user over to my second worksheet named form where the range of cells are. I would like for it to wait to take them over after they press the command button because multiple check boxes will need to be checked. Any help is greatly appreciated. Option Explicit Private Sub CommandButton1_Click() Call CheckBox2_Click End Sub Private Sub CheckBox2_Click() If Me.CheckBox2.Value = False Then ...

listview control display as a group #2
I have a requirement to display the list items as group. I have been trying to use the CListCtrl::insertGroup() method. The method works fine but the grouping doesnt show it does show the items just as regular items. Here is the code: <html> <head> </head> <body> <font SIZE="2"> <font SIZE="2" COLOR="#0000ff"> <p>void</font><font SIZE="2"> Ctt1View::OnInitialUpdate()</p> <p>{</p> <blockquote> <p>CListView::OnInitialUpdate();</p> </font> <p></...

how do I add a 'web address' to a cell in excel with a hyperlink?
how do I add a 'web address' to a cell in excel with a hyperlink? I am a new student to computers, and part of a test is to insert a hyperlink to a cell in excel linking to a web address. I have searched computer for any 'Hyperlink' connection words, but I think it not on here, Is that possible, although I have top of range computer. Anyone with a solution? I be ever so greatful. in xl2002 ctrl+k>in the link to select existing web page>either type in (at the bottom) or point to the url on your browser>enter -- Don Guillett SalesAid Software dguillett1@austi...

Downloading Crystal report 9.2.2
Hi, I am trying to download and install Crystal report 9.2.2. I found a link in one of the postings ftp://ftp.crystaldecisions.com/outgoing/TS/CC/CRPro922.zip, but it seems like the link is no longer valid. Could anyone guide me to where else I can download Crystal Report 9.2.2? Thanks in advance, Alvin Hi Alvin, If you have a license for v9 you can get 9.2.2 by contacting BusinessObjects. They will validate your crystal 9 license then either send you 9.2.2 or give you a download location. You can download from the following location but you need login details - https://businessobj...

Deleting a store from HQ #2
We have a customer that bought a 24 store HQ license and set up 25 stores, and now his HQ won't work because he has to many stores. How would I go about deleting a store to fix this situation? Any help would be appreciated. LAllison wrote: > We have a customer that bought a 24 store HQ license and set up 25 stores, > and now his HQ won't work because he has to many stores. How would I go > about deleting a store to fix this situation? Any help would be appreciated. You can delete the 25° stores from databases via sql .. cod How would I delete just one of them?...

Linked Cell Property In Activex controls
Can someone point me to an example showing how this property can be used, linking, as an example, an option button to a specific cell? Say if I wanted "1" to appear in cell B2 of the worksheet if the option button is clicked KG, The option button puts TRUE or FALSE into its Linked Cell. You can get 1 or 0 out of that by referring to it with double negation operators. = --A1 -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "KG" <KG@discussions.microsoft.com> wrote in message news:924E6B40-6040-4016-B75B...

Removing Blank Cells #3
I would like to know if there is a way to remove the blank columns and rows from a worksheet. There really is no need for this many blank rows in the workpaper I am working on and I assume it contributes to the overall size of the spreadsheet. Thanks in advance. Hi you can't remove them (you can hide them if you like9. Also they do not add up to the size of your worksheet 8at least as long as your used range is correct) -- Regards Frank Kabel Frankfurt, Germany Jeff Mortenson wrote: > I would like to know if there is a way to remove the blank > columns and rows from a works...

shared sa password
Hi all, My client is using Microsoft Great Plains v8. They have 4 people that knows the sa pasword, the password is never changed and 3 of them has system maintenance access. just wondering, i'm pretty sure there can be a security issue there. i dont know much about microsoft great plains, but could you share a quick thought of what can go wrong when the above happens.. btw, they are all working in finance. Cheers, Thano. Having the 'sa' password would enable them to perform actions using Query Analyzer, Enterprise Manager, and other SQL tools if they were able to gai...

GP 9.0 SP1 issue??
When on GP 9.0.114 we were able to apply from Cash Receipts(CR) window. Had to apply SP1 because it had a fix for "Recevings amount overstated" issue we had in POP receivables(we do use PA). Now we are on GP 9.0.259. We no longer have the "Receivngs amount overstated" issue. However we cannot apply from Cash Receipts window or Apply Sales window. We get SmartHeap Library MEM_LOCK_ERROR consistently on all our entities. and in all our client workstations. -- any ideas? Do you have any modified forms or reports? This problem may occur because one of the following files ...

Display Sheetname in a cell
I'd like to display a worksheet name "with the body" instead of "in the margins" (ie, using Header / Footer definitions). Is there a built-in mechanism for picking up the worksheet name in a formula? I tried putting Function GetSheetName() As String GetSheetName = ActiveSheet.Name End Function in a code module and " = GetSheetName() " in a cell; but quickly discovered that <F9> doesn't cause the user defined function to re-evaluate. Suggestions? -- Clif Try this: =MID(CELL("filename",A1),FIND("]",CELL("fil...

Hyperlink directly to a cell in a worksheet
Hi there, I'd like to hyperlink directly to a cell in a spreadsheet (spreadsheet opens to a specific cell selected). The link I'm using opens the spreadsheet, but it goes to the same cell everytime. Is there a way to do this? Thanks in advance for any help. Here's what the link I'm using looks like: www.myserver.com/Payroll_Risks_&_Controls.xls#='Risk Scores 1, 2, or 3'!$A$27 Risk Scores 1, 2, or 3 is the name of the worksheet and A27 is the cell I want to go to. ...

Crecordset::addnew functionality fails #2
This problem is about recordset functionality. Actually, When using RFX_Int, value 32484 is being treated as null and can't be entered. So converting RFX_Int into RFX_Long and type casting the variable to long can solve this problem. Look at the link: http://support.microsoft.com/kb/170257/en-us But again, value 1246576928 is being treated as null in case of RFX_Long. And when tried to type cast the variable to double, it shows the fractional truncation error and numeric out of range error. So wouid anyone please let me know: 1)How to resolve the issue? 2) How value can be entered in data...

inviting investors, students, entrepreneurs #2
http://garunar.wordpress.com/ PRIVATE UNIVERSITY COLLEGE owned by students, entrepreneurs DIGITAL EARTHLINK CONNECTING ENTERPRISE EqUaL OPPORTUNITY RESEARCH/SCHOLARSHIP- MBA, BA, BSC, MPHIL., MRES. EDUTAINMENT Homemade Re-Defined WEALTH MANAGEMENT Jewels of Orient: Fast-track wisdom ECONOMIC INCUBATOR LIFETIME HEALTHCARE, online CLINIC & Ayurveda GLOBAL MARITIME/ LAND BUSINESS with over 16000 boutique luxury businesses including 8000 in Asia BEHAVIORAL FINANCE/CANCER THERAPY/ MULTICULTURAL vipassana CEOs, Glamour, Parties, Garunar schools offering microfinance DIGITAL EMPIRES FOR EMOT...

Outlook Client v 1.2 not working in offline mode
Hello, we have installed several CRM Outlook Clients, version 1.2, on the laptops of our salespeople. They are able to work online perfectly, and when going offline, synchronization seems to work, as well. However, after going offline and synchronizing, when they try to open any of the CRM folders, they get an "Access Denied" message (this does not happen in online mode!). I have adjusted the permissions on the UNC Snapshot share on the SQL server, and the Publication Access Lists on the SQL server, and still get the same errors (identical on all of the clients). Does anyone have a...

drag and drop problem with cell references
i have a cell with a formula in one worksheet that references another cell. the formula looks like this: =IF((ISBLANK('Draft'!$D25)),"",'Draft'!$D25) where 'draft' is another worksheet in my workbook. the formula works fine, it looks empty if there is nothing in the referenced cell('Draft'!$D25), otherwise it mirrors the content of that cell. If i type something in the referenced cell('Draft'!$D25), it still works great. But if i drag something to the referenced cell than the formula gets screwed up and replaces the $D25, with #ref. I am gue...

Determine if another cell is hidden in a Formula
Hi! I would like to display a special message in a cell when another cell is hidden. Is it possible? Something like (in cell A2): =If(IsHidden(A1), A1, "") I guess I could do it with a user function... but if I use that in a lot of cells (hundreds) it might significantly slow down the refresh speed... Any thoughts ? J Whales ...

Need help removing characters in multiple cells
I have an excel 2007 sheet that has over 300 cells in a column that have a name of a store plus a number between paranethesis. Is there a one step way I can remove the paranethesis? Here is an example: K-Mart (ABC#73846365) and I want to have just the following K-Mart Each cell has a different store name and set of numbers within the paranethesis. Thanks Select the range to fix. Edit|replace what: _(* (spacebar, open paren, asterisk) with: (leave blank) replace all It looked like you'd want to remove the space character after the t in k-mart. "<----- Mardm...

Outlook contacts list issue
I am in the process of recovering data from an anchange disaster. I had all of the mailboxes recovered and are all in PST files. I am now going through and showing users how to import their calendars, contacts, mail etc. When a user imports his/her contacts, everything goes fine until they try to use those contacts through the address book. The address book does not show any contacts added by the import. Any newly created contacts are visible. I have found that if I change the email address of an imported contact, that contact will then appear in the address book. This indicates ...

quick way to combine 2 files?
If you have two excel files, both of which have 3 or 4 worksheets that are all used in lookup routines etc etc, is there an easy way to combine the two into a single file, as I think it won't work just by copying and pasting individual worksheets over in their entirety tks in advance LeeH Lee, With both workbooks open, group the sheets of one workbook (using Ctrl clicks on the tabs) then right click and select Move or Copy and then move them into the other workbook. HTH, Bernie MS Excel MVP "Lee Harris web" <lee.harris4@virgin.net> wrote in message news:32c0bd8d.04012...

remember path when linking many GIFs to cells?
When I link a number of GIF images residing in a different directory to Excel 2002 cells, the program does not remember the last directory it looked in when a new link is entered. Is there a way to set up a default path for this boring operation? Thanks, z.entropic ...