Programming

Average various variable ranges
Hi, I posted this question before, but I cannot find the thread of it anywhere, so I am posting it again. If it is duplicated, please forgive me. I have 90 000 rows of data that is in the following format: CW001P01-SH-C: Time Duration Partition Utilization % 20/03/2010 23:56 900 86.3521441 21/03/2010 00:11 90... 21 Apr 2010 08:26

Error message : You must select a shape
Running Excel 2007. After I clicked on the Page Layout and Page Break Preview buttons and then back to the Normal button on the View tab, I started getting this error message whenever I pressed one of the arrow keys to move the active cell. Ctrl-Home did nothing. Clearing the message just cleared the message. Press... 21 Apr 2010 03:16

Run Time Error '1004' Application or Onject-defined
Hi all. I am having a strange problem with the below code in that it produces the run time error when trying to Paste the Selection. However, if I perform the action manually in exactly the same way, as in recording the macro in the first place, it works!? How can I get this to run - it is after all, a really si... 21 Apr 2010 01:11

Help with code
Hi, I need help to improve this formula to display multiple instances of the unapproved EOT's. Extension of Times that are not approved. ie....... 'EOT Register'!$O$2:$O$92,0)=0 =IF(COUNTIFS('EOT Register'!$D$2:$D$92,Program!C372,'EOT Register'!$O$2:$O$92,0)=0," ","EOT under review - "&LOOKUP(C373,'EOT Re... 21 Apr 2010 00:07

VBA: How to match two sets?
In VBA for Excel (2007), is there an easy way to get a True result if *any* character in one set matches *any* characters in another set? If I understand the Like operator, the result is True only if *all* characters in the first set match a character in the second set. I would like to pass a string of debu... 21 Apr 2010 06:22

Count previous 30 cells two sheets
I have 5 sheets each one is 1 year. On each sheet in column J I am keeping a total of how many times “Y” has been placed in column B for the previous 30 days. In J36 Jan 31 2010, I have =COUNTIF(B6:B35,"Y"). That works fine; it counts the previous 30 days. Row 6 is the top of my page, so in J35 I would like it... 21 Apr 2010 02:14

Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
I have this strang excel file. When I enter formular into it, it don't show thae value but when I enter anything else in the cell, that is visible. The formula is in the cell, its just not visible. ... 21 Apr 2010 20:53

Search and Replace, or Add New Row
I am using Excel 2003. I mistakenly posted this originally under General Questions. Worksheet1 contains columns (A) Invoice (B) Name (C) Address (D) P.O.# ... and others. I need to perform a search of column A using an invoice number and if it IS FOUND, then replace the entire row with new data. I... 15 May 2010 11:32

excel extract data from one sheet to another
a b c Name Vault Rank Blake, Jasmine 7.900 1 Fattouche, Chloe 7.600 3 Fattouche, Nicole 7.700 2 Pratt, Erika 6.100 5 Salem, Alexandra 6.300 4 Mills, Sara 7.700 2 Ranked compares each via =SUMPRODUCT(--(C5<$C$5:$C$148),1/COUNTIF($C$5:$... 21 Apr 2010 09:28

autoscale stock chart
Hi All, xl2003. A candle stick stock chart with some moving averages is located as a new sheet. Trying to autoscale it using the next macro: Dim intMax1 As Integer Dim intMin1 As Integer Dim intMax2 As Integer Dim intMin2 As Integer Dim rngMin As Range Dim rngMax As Range Set rngMin = Worksheets("Stock Data... 22 Apr 2010 01:01