excel 2003

Hello all! So I am quite new to conditional formatting and the use of VBA Editor in Excel. I am working on putting together a spread sheet that contains Item numbers and pricing from my works data base and that of our vendors. I am wanting to have conditional formatting that will highlight a...

Hi All, Thanks for looking at the post. I have written code to select all (from webpage), copy and paste (in excel sheet) in Excel 2007 and it is working perfectly. But when my client who uses this program on 2003 version, he gets Error 1004. "Class worksheet pastespecial' Following is the...

Im trying to convert the following formula to 2003 version. Please help =COUNTIFS(Dropships!G2052:G2999,"="&TODAY()-1, Dropships!L2052:L2999,"Y", Dropships!M2052:M2999,"<"&TODAY()) I need the formula to count the number of cells that contain "07/24/2014" or before that date in M column and...

Been struggling trying to come up with an average calculation that allows me to only sample the last 10 days, on a continuous basis. I would like to add new data to my spreadsheet everyday and not have to re-write the average formula to only sample the last 10 days(or 7 days) below is a sample...

Hi, I have a spreadsheet (in excel 2003) containing a years worth of timesheet data, arranged into columns which include job number, stage and the days of the week for Monday-Friday. Hours per day are put against a project and/or stage. The spreadsheet is arranged into worksheets with two weeks...

Well Hello, it has been a while since I posted. I have searched the forum, but can't find an answer. I don't use Excel as much as I used to (career change) just personal stuff now, and I am perfectly happy with Excel 2003 for what I do. I now have a new laptop running windows 8.1, I was...

I'm a low-income disabled senior, so I get by with hand-me-down hardware and software. A decade or so ago, when I could more easily get out and around, I managed the ordeal of taking a bus trip (three buses each way!) over to Microsoft for an afternoon of product testing. I was rewarded with a...

I'm an old guy disabled by worsening chronic illness and cognitive deficits and I can't remember how to look at a macro I used to have in an Excel 2003 spread sheet of my medical records. Yesterday when I opened that spreadsheet the macro didn't work as it usually did. So I figured that the...

Hello everyone, I'm still new to VBA and trying to figure out how to copy the innertext from the description of a certain website. I'm using Lenox.com (Official Site) - Unique China & Giftware by Lenox and After I get VBA to go out to IE navigate to www.lenox.com and search a sku number. I...

Hi, I have completed my code with 2010 and have have checked it on 2007 and both work great. When I try and use it on excel 2003 I get the runtime 438 error. The error occurs (in bold) on the Sort portion of my code, shown below. Is there anyway I can modify the code to work with excel 2003...

Hi all, I know this question has been asked over and over again, but no matter how much I search I dont seem to able to find a suitable resolution. My challenge would seem to be simple, but I am unable to sort it out by myself. I work in a call centre and I record my daily figures. My target is...

I have the following function in an 2010 spreadsheet and need to use it on several work stations with 2003. Unfortunately the boss said no go on upgrading Office. I know a SUMPRODUCT or combination SUM and IF will work, just having trouble getting the correct transpose. Please help. Thanks...

Hi All How would I modify the below simple code which looks for the first empty cell in Column A within the whole workbook, so that it only searches for the first empty "A" cell within a range of rows? As it works from the bottom of the sheet up, and I have data below the area I wish to search...

Hello to all. Have a quick one for everyone to mull over. To start, using Excel 2003 (don't say it, I already know :banghead: ). I have a protected sheet with Autofilter boxes located from A4 to Y4. I need to be able to have a macro check the columns to see if any of the filters are active...

Hi to all, I want to say from the start that I am new and I don't have any exprerience to VBA language!. However I know clearly what I want to do. THE GOAL: I am using EXCEL 2003 and I want to record the values from a group of cells when they change, at a different sheet, let's say LOG_ELEV...

Hi, We've recently upgraded to Office 2010 and some locally stored macros are causing issues. This one is regarding a conditional formatting macro after importing data from an XML file. The code is below: Sub Macro3()' Range( _...

The following code was used to create a chart in excel 2003, but doesn't seem to work in excel 2010? When I run the debugger, the line in red below is highlighted. I am a new user of VBA, please help! Sub TraceXYMulti() Dim myCht As Chart Dim mySrs As Series, Isrs As Integer...

Good Day I have been given a task to create a register for another department within our company. My original register was setup with the help of all the wonderful people on Mr Excel. The new register I have to create is pretty much the same, however the formula I used before checked for 2...

Hello Everyone, I built a sheet in Excel 2010 that contains the following VB code: Private Sub Workbook_Open() Application.CommandBars.FindControl(ID:=2521).Enabled = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean)...

Hi Guys!:) I found this amazing vba code online: Function DataBar(lngValue As Long) DataBar = String(lngValue, ChrW(9608)) End Function Basically allows me to generate these "bars" to represent my data. However; it doesn't generate bars for negative data... I was wondering if it is...