bug

Open a macroenabled excel workbook and then run: Public Sub wrt() Worksheets("Sheet1").Select Lastrow = Range("A" & Rows.Count).End(xlUp).Row Cells(1, 1).Value = Replace(ActiveSheet.Cells(1, 10000).Address(0, 0), ActiveCell.Row, "") End Sub Everything works as it should. Now add another zero...

https://dl.dropboxusercontent.com/s/3j6go4orfx0fjmn/Merg.xlsm?token_hash=AAEiQNgZfZaDuLS8155L0_q_kJZxHcX3GEKKkk02tToeyg&dl=1 This Merge1 procedure is really buggy. Sometimes it works and sometime it dont. Just recently the error message was: "method run of object _global failed" How can I...

Greetings. First time post but long time viewer. I've got a weird issue that seems like a bug with Excel 2007 Conditional Formatting. Perhaps someone can fill me in if I'm missing something or if there's a work-around. I am trying to apply conditional formatting to a wide range of cells. I only...

Ok I have a worksheet with two sheets: Download and Historical The Download sheet looks like this: SSE [% Chg] Aarhuskarlshamn ABB ... kuk Friday, April 20, 2013 -0.48 -0.29 ... 5 The...

Hi, I have a large flow diagram where I've drawn arrows by inserting shapes. When I scroll around sometimes the lines are there, sometimes not - I have to keep on scrolling around until they turn up. Is this a bug? Or is there a way round this? I'm using Excel 2007 with SP3 It is really...

I have a worksheet with 7 or 8 columns in it, with the source data copied from another spreadsheet. When I pasted it into my new worksheet, some rows display (and print preview also) with an extra line below the text. The font is Calibri 11 point, and the zoom is 100%. I have done a number...

I got a problem, I set up a formula for a search function and it seemed to work just as I wanted it to, however, on one number (30010) it returns everything but the intended, I get zeroes in some cases and random numbers in other cases. Note I use 2010, so what used to be , is now ; The array...

I have a problem where Excel 2010 is deleting one of my conditional formatting conditions. I do not know if it is deleting it on open or close. I just know that I enter the conditional formatting, save the workbook, close the workbook, reopen the workbook, and it is gone. The other conditional...

I'm at my wits' end with this - I've searched multiple places on the web and gotten exactly 0 working suggestions, though it seems other people have run into this problem as well. I'm using Excel 2007 SP2 on Windows XP. The problem is that when I open my spreadsheet on computers with...

Somewhere in the past 48 hours, my Excel 07 CUT function turned into a COPY function. i.e. I either use the cut button or the CTRL+X and visually nothing happens (no selection rectangle), but when I paste, the proper content is pasted - and is now in the original range, and the pasted range...

I have an excel macro. When I run the macro without a breakpoint, the spreadsheet calculates slightly different values than when I run it with the breakpoint. Unfortunately, when the macro is run with the breakpoint, I get the correct values. Any ideas on what is happening? Mike

Sometimes, when I enter information into a cell, say, h264 on sheet1, the information will overwrite h264 in sheet2 and sheet3. This has happened to me on two previous projects, and it has started happening on this project as well. It happens even when I restart excel and open up the same...

Hello, I am using Excel 2007. I am using the unique rank formula =rank(value,range) + countif(range,criteria) - 1 to give me unique ranks for a set of dollar values. I have two values of .011 that excel will not give me a unique rank (and they are exactly .011 each - they have the same exact...

Hi all. Could somebody please shed some light on the reason office engineers made it available for users to choose to still edit cells after marking a workbook final?? What's the point of that?? And how do I prevent them from doing it? Thanks in advance

Hi everyone, (Windows 7, Excel 2010) I'm using the INDIRECT and MATCH formula functions to create a data validation drop-down list that is based on a variable-length list of data items. When I setup the data validation list, everything is fine. But when I save, close, and re-open the...

I have 3 excel workbooks. I am attempting to link a chart from workbook1 to workbook2 by the paste special method. Workbook2 already has a linked chart in it from workbook3 and works perfectly fine. But when I link a new chart from workbook1 to workbook2 only a blank object appears. The...

My pivot chart displays the data from the grand total of the pivot table, though I have set the data to pull from the column immediately to the left (whether or not I display or don't display totals). Further, when I move the cursor over the line on the graph, the line point retrieves the...

Hi, please see the details below: Background: Excel 2007 Shared workbook with Autofilter and Frozen Panes. Issue: When a user filters the information and then saves the file, excel changes the frozen panes automatically depending on the filtering used (yes, it does it by itself) even when the...

I have a simple sheet with three ActiveX controls (one for each report) and a pivot table. The Pivot tables shows a list of parts associated with a charge unit. The user selects the charge unit in the pivot table then clicks the ActiveX control for the report they want. Sometimes the user...

Hi all. I'm running a very simple SELECT query off some Oracle tables in Access 2007. When I first run it, I get 8,237 records appear. The last one is a duplicate which, as far as I can tell, shouldn't be in the results. When I sort the results by the ID field, I only get 7,853 records, and the...