Programming

macro alternate conditional format change
Excel 2003 SP3 have spreadsheet with percentages in cells; some cells have "N/A"; already using conditional formatting (3 conditions) to change cell background color for percentages; want background color of cells with "N/A" to remain clear (white); need a macro that will find cells with "N/A" and change them ... 12 Feb 2010 15:44

Media Player Help
I have be working to get the Media Player to run small sections of longer audio and video clips. I am having some success, but have hit a number of dead ends and was hoping to get some help. Working in Excel 2007 on an XP machine, the following code works great for an object using the Media Player (msdxm.ocx)... 22 Feb 2010 09:38

Filesearch Errors
This is my first time developing/editing macros since switching to Office 2007, so I'm wondering if I have a setting wrong someplace. I'm trying to run a routine I used in the past to list all files in a particular folder in a worksheet. Because I was having trouble getting this to run, I searched the Excel h... 12 Feb 2010 13:29

XL03 suppress 'missing XLA' msg on Workbooks.open
This started in another thread, but that thread got orphaned and I've got a clearer idea of what is happening now, so reposting in search of additional help. Thank you all for your continued assistance. I have a file that I open with UpdateLinks:=0 My goal is to automatically open this file from a LAN, copy t... 12 Feb 2010 11:11

add/sub time/hour tracking in 24 clock format
I am trying to write a formula to track time and hours based on a 24 hour clock format (without the bloody ":" 's). My problem is, I've a formula that does what I need, but when I try to input that to my workbook, it doesn't work. In my "scratch sheet" doc, it works, when I write it into my actual book, it do... 12 Feb 2010 12:21

Updating dates
I have a worksheet and I want the date in Cell A5 to show current date if the pivot table on the worksheet refreshes. Can someone provide the code? I have another worksheet and I only want date in Cell E2 to update if any edits were made in worksheet. Can someone give me code for this? Thanks, Aidan. ... 12 Feb 2010 08:56

Simple Macro to Auto fill Cells
Hi Everyone, Hope you are all well :) I have a very simple excel worksheets (Worksheet A and Worksheet B) which has: Column A: Empty Column B: Has entry (First Name) on every cell till row 2000 Column C: Has entry (Last Name) on every cell till row 2000 I know how to get first and last name combined ... 12 Feb 2010 02:14

find header then replace header with number of entries below heade
I have a data set that contains over 66,000 lines. I would like to search for each 'nan nan' then replace it with the number of entries that follow until the next 'nan nan'. Ex. the first 'nan nan' to be replaced with '7', second with '17'. I would also like to enter a '1' in the cell to the right of each rep... 12 Feb 2010 06:43

I'm Paste values stupid
I'm trying to do something very simple. I go to a sheet and select a range and click copy to copy a range. I switch to another workbook and click a button. The code attached to the button should paste values into the active sheet starting at cell "A3". It's ridiculous because this should be easy; I even record... 11 Feb 2010 20:46

Reference a cell value in a formula
I have the following formula: =SUMPRODUCT((MONTH(Summary!$F$7:$F$15000)=1)*1) I want the "15000" to be replaced by the varaible value of a cell in an other worksheet ("Summary"). I tried using INDIRECT but it didn't work. Thanks in advance ... 12 Feb 2010 08:56