To anyone who can help me: Occasionally I receive an Excel attachment with an e-mail were some of the text in some cells appear in the formula bar but not in the cell itself. Would greatly appreciate assitance . . .

0 |

5/19/2005 5:46:08 PM

Here is exactly what I am trying to do through VB in Excel: Weekly data pull fills colums A:G. Row count is always different. I am modifying the data pull through VB, and I have a VLOOKUP formula in cell H2. What I want VB to do is copy that formula down column H to the last row (with data) each week. I guess I want it to be dynamic so that as rows decrease/increase the formula is only copied down to the final row/record. I know someone out of this smart group will know how to do this! Thanks in advance! Tony (pseudo code) in a macro .... dim lngLastrow as long dim rngTarget...

I have a control field on my form that is setup as textformat = rich text. In the memo field on the form I need specific parts of the text to show up as bold. Upon form load I am populating the field with string data such as: Me.MyTextBox = "This is a test string generation." I need to set bold only one or two words of this string. The way I understood it was that if I was using Rich Text format it would convert the formatting to HTML style. But I don't see and havent found examples HTML formatting like [b] [/b] working in VBA. What is the correct way I can do t...

Hi All I'm trying to display some information about my main window in the control bar, specifically the magnification and the x & y coordinates of the mouse. After some work I got the Combo Box that displays the magnification working but I'm stumped on the coordinates. First thing is the VC++ class wizard doesn't seem to generate a DoDataExchange function for CMDIFrameWnds so I had to write it myself, but once I did, the ComboBox was happy. I've defined the mouse coordinates as static text, IDC_XVAL and ICD_YVAL, in the Dialog bar, though they don't show up as the ...

I need help trying to come up with a formula for a friend of mine. This is what he wants -- Using any 9 numbers -- he wants Excel to come up with every possible 3-digit combination of numbers that are divisible by 7. Is there anyone who could assist me with a formula that will perform this calculation? Can Excel do such a calculation? Thanks so much for any assistance you can offer. In A1, enter the number 7. Select A1:A142. Edit>Fill>Series, Step value 7. Format>Cells>Custom, "000". If with "using any 9 numbers" you mean you don't want any zero...

I'm trying to use a Select Case in a Private Sub Worksheet_Change event to do the following: if I type w in a cell in col B, I want to replace it with WIDGETS if I type g in a cell in col B, I want to replace it with GIDGETS seems like it should be simple but I can't come up with the code. On Sun, 10 Jan 2010 10:28:54 -0600, "John" <nodak457@yahoo.com> wrote: >I'm trying to use a Select Case in a Private Sub Worksheet_Change event to >do the following: > >if I type w in a cell in col B, I want to replace it with WIDGETS >if ...

Using Excel 2002. I have a workbook with 12 worksheets (one for every month of the year), wherein a lot of the information is looked-up (using VLOOKUP) in simples arrays. I saw no point in implementing the arrays as a 13th worksheet, because I will have a yearly version of my monthly worksheets in one workbook (so one for 2003, 2004, etc). If I change the array(s), I want them to be reflected in all referencing cells. Problem: If my workbook containing my arrays (called "Global") is loaded, I have no problem and the references to it read as: (blabla) 'Global.xls'!Roster ...

Can I increase the # of characters that are visible in a cell? 67 Excel Help on "limits" or "specifications" reveals that Excel will allow 32,767 characters to be entered in a cell. However, it goes on to state that "only 1024 characters will be visible or can be printed" To work around this limitation, stick a few ALT + ENTERs in at appropriate spots. The ALT + ENTER forces a line-feed and expands the 1024 limit. How far is not really known. Just experiment. .........From Dave Peterson.......... I put this formula in A1: ="xxx"& REPT(REPT(&...

Let's say I have a spreadsheet with two worksheets = SheetA and SheetB. SheetA might reference a cell in SheetB with a formula like =SheetB!A1 But when I move this to the network the reference changes to include the network drive and file name like: ='Z:\FOLDER\[FILE]SheetB!A1 the file may move from my laptop to the network several times and this becomes completely confusion as the reference looks, not within the same spreadsheet which is what I want it to to, but for another file out on the network. How do I explicitly reference a cell within a difference worksheet but alwa...

"" generates a zero-length string, not a truly empty cell. This is causing problems elsewhere. I'd like to find an output for an IF statement that will give me a truly empty cell. The current formula is: =IF(COUNT(C24:C29)>0,SUM(C24:C29),"") Any ideas? If it involves a macro (as I think it might, having read other posts), please explain how to implement it. Thanks! <This is causing problems elsewhere> It shouldn't. Don't use ISBLANK(A1), use A1="" -- Kind regards, Niek Otten Microsoft MVP - Excel "paulkaye" <paulmjkaye@gm...

Is there a way to make the bars in a graph transparent? Hi, Here is a work around. http://j-walk.com/ss/excel/usertips/tip071.htm Cheers Andy Tiffany wrote: > Is there a way to make the bars in a graph transparent? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info Thank you! That is exactly what I needed to know! "Andy Pope" wrote: > Hi, > > Here is a work around. > http://j-walk.com/ss/excel/usertips/tip071.htm > > Cheers > Andy > > Tiffany wrote: > > Is there a way to make the bars in a graph transparent? > > -- &...

in cell A1 i have the numbers 123456789. i want cell B1 to have numbers 1234567 and cell C1 to have just 89. what is the formula? i have tried text to columns If this is for extracting the first 7 characters use LEFT() =LEFT(A1,7) =RIGHT(A1,2) -- Jacob (MVP - Excel) "fazz" wrote: > in cell A1 i have the numbers 123456789. i want cell B1 to have numbers > 1234567 and cell C1 to have just 89. what is the formula? i have tried text > to columns Hello Jacob - i did not explain this very well.The digits in cell A1 is variable length. In cell C1 i n...

Hi! Does anyone know how to write this formula in Basic. I need to make it work in Openoffice because Excel seems to crash with a list of 20000 people. =IF(ISERROR(VLOOKUP((RC1&R1C),Sheet1!R2C1:R45000C4,4,0)),"""",VLOOKUP ((RC1&R1C),Sheet1!R2C1:R45000C4,4,0)) Thanks!! ...

Can anyone help me write a formula to find the date of the second sunda in a given month? Thanks in Advance, Dav ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com David, Assuming you have a date in A1, this gives the 2nd Sunday of that date =DATE(YEAR(A1),MONTH(A1),1)+MOD(8-WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)),7)+7 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "DavidObeid&q...

Hello, I like to see if anyone is able to help me come up with a formula or function that will do the following for me: I have a set of 9 computer generated (somewhat random) numbers. THESE NUMBERS WILL NOT BE IN AN ASSENDING OR A DECENDING ORDER. Example is something like the following set of numbers: 18.34, 19.37, 20.4, 19.38, 17.96, and so on, up to nine numbers. I CAN ORDER THESE NUMBERS IN A ROW OR A COLUMN, EACH IN A SEPARATE CELL. HOWEVER, THIS IS HALF OF THE PROBLEM!. NOW I have another number, I WILL CALL THIS NUMBER MY CONTROL NUMBER. This control number (19.11...

Print or Print Preview not showing text using PP2007 just released SP2 for office Now when we try to use print or print preview only see some of the text headers. None of the text is showing or the background or images, using built in templates. Worked bofore After testing, I found I have to set the color/greyscale - to colour to actually use the print preview. But it previews in grey scale, can't even see the preview in color. Unless I also go into printer settings and change that to color then get colour in preview. If I set it to grey scale and my printer is a ...

I want to multiply text boxs ie 4(1box)x $1.00(2box)=Total $4.00 (3box). I also want sum total (5 text boxes) for grand total. Is this feasible on form?? Thanks On Mon, 14 Jan 2008 18:58:01 -0800, He cries for help <Hecriesforhelp@discussions.microsoft.com> wrote: Have you tried an expression like: =[1box] * [2box] (assuming your control names are 1box and 2box. This expression would go in 3box' Control Source property. -Tom. >I want to multiply text boxs ie 4(1box)x $1.00(2box)=Total $4.00 (3box). >I also want sum total (5 text boxes) for grand total. > >Is this ...

This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C5AE18.43CE9F70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, When I reply to a message from within OWA, I get a broken link in the = areas where I would type. It's as if it can't find the form or = something. It's not a signature file problem from what I can tell. Any ideas? ------=_NextPart_000_000B_01C5AE18.43CE9F70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC &q...

I have 3 columns of single figures. At present i'm using the sumproduc fuction to multiply and total the figures in column A that fall betwee 4 and 9 with the adjacent figure in column B... =SUMPRODUCT(--($A1:$A600>=4),--($A1:$A600<=9),($B1:$B600),($A1:$A600) I'd like to add column C to the formula, so that if it contained value of -1, 1 or 2, the sum of the adjacent figures in columns A and appears as a negative number. For example A3= 7, B3= 2, C3= 1 Outcome= -14 A4= 9, B4= 1, C4= 5 Outcome= 9 A5= 3, B5= 2, C5= 2 No sum because figure in column A ...

Hi I need some help on the following. I have a column of text, linked to other worksheets, that is continuously changing. I need to be alert if the same piece of text appears in the column more than twice, e.g. Tom Tom Jane Mary Mary Tom "ALERT" Thanks Mike -- mlhynes ------------------------------------------------------------------------ mlhynes's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12959 View this thread: http://www.excelforum.com/showthread.php?threadid=401787 Mike Visit Chip Pearson's site for much help on duplicates. Fin...

I have a 267 characters texts field. MS Excel 2007 will not show all the texts. It showed a bunch of ## symbols in the cell. I have tried several tutorials on how to wrap texts but it didn't work. I have tried these: http://www.dummies.com/how-to/content/how-to-wrap-excel-2007-data-to-see-all-the-text.html http://blog.taragana.com/index.php/archive/how-to-wrap-text-in-ms-word-2007-and-ms-excel-2007/ http://www.5min.com/Video/How-to-Wrap-Really-Long-Text-in-Excel-110694838 And it didn't work. The cell still shows the ## symbols. Any help is appreciated. Format the cel...

I have imported data into Excel. The left-hand column has merged cells containing a reference number. The remaining columns contain varying records associated with the reference number, a one to many ratio. I need to display the worksheet so that the appropriate reference number is displayed in the left-hand column for each of the records in the worksheet. There are hundreds of reference numbers. Is there an automated way to do this besides unmerging each section and copying the reference number into the now unmerged cells? Thank you. ...

How can a frequency of a specific character be counted with in a cell. Ex -" #4 Bluebirds, #6 Aquatic" is in cell B2 - how do I count the number of "#" that appear in cell B2? =LEN(B2)-LEN(SUBSTITUTE(B2,"#","")) HTH Jason Atlanta, GA >-----Original Message----- >How can a frequency of a specific character be counted with in a cell. Ex -" >#4 Bluebirds, #6 Aquatic" is in cell B2 - how do I count the number of "#" >that appear in cell B2? >. > ...

Can anybody tell me how to get this to work? In other words, how do I reference my procedure variables in a cell formula? Thanks! Sub Marktest() Set b = Cells.Find("Total", , xlValues) Set c = Range("C5") Range(b.Offset(-1, 2), c).Formula = _ "=sumproduct(($B5=Range(b.Offset(-7, 1), b.Offset(-5, 1)))*$C$1:$C$3)" End Sub I'd do something like: Option Explicit Sub Marktest2() Dim myRng As Range Dim b As Range Dim c As Range With ActiveSheet Set b = .Cells.Find("Total", , xlValues) Set...

I wish to change the text in the legend box from say- (Series 1) to (MPG) or anything that has a relevance to the graph. This was done easily in Works Spreadsheet and previous versions of Excel. Using 2007 Student & Home version. Hi, Select the chart and use the ribbon Chart Tools > Design > Data > Select Data On the dialog select the appropriate series and Edit. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mareng" <mareng@discussions.microsoft.com> wrote in message news:CDF2E10C-04F5-411E-94C0-2504B48C1900@microsoft.com... &...

A database query program outputs everything as a text string. One of the fields is a date, formatted as yyyymmdd. Is there a worksheet function that will change this to an Excel-recognized date? Or a macro? The error checking doesn't flag this. Ed With your text date in A1, try this in B1: =DATE(LEFT(A1,4),MID(A1,5,2),(RIGHT(A1,2)) Hope this helps. Pete On Dec 17, 1:12 pm, Ed from AZ <prof_ofw...@yahoo.com> wrote: > A database query program outputs everything as a text string. One of > the fields is a date, formatted as yyyymmdd. Is there a worksheet > function t...