Macro Bombs Excel 2000

Jun 1, 2009

I've developed a workbook with macros in Excel 2007 (Compatibility

Mode), Windows Vista Operating System. The purpose of the Macos

is to allow auto complete on a validated data entry field.

The macros run fine on this platform. I then copied the workbook

to my desktop, Excel 2000, Windows 2000 Professional Operating

System. One of the macros is killing Excel on this platform.

View 14 Replies


Excel 2000 :: Macro Calling Unrelated Function?

Jun 9, 2014

the macro works fine until it executes the paste values. At that point, the macro jumps to the "CountThem" function which is located in another workbook. The data that I am copy/pasting is in no way connected to any cells that are using that function. Although, other values in the workbook are passed down from data that uses that function.

I am still in the dark ages using Excel 2000.

This is the code for my macro.

Sub Current_to_Raw()
' Current_to_Raw Macro
' Macro recorded 2/12/2014 by


View 2 Replies View Related

For Each Sht In Sheets Bombs On Chart

Dec 27, 2006

I created a chart with F11. It becomes the first, well, "sheet" in the workbook, Chart1. It's active when I go

Function foo()
Dim wksht As Worksheet
For Each wksht In Sheets

Boom. Now what do I do? I can't just go in error trapping code - can I??!!

View 9 Replies View Related

Excel 2000 - Show Billable Days

Dec 16, 2008

I have been asked to create a spreadsheet that will contain three fields;

Date of placement (the day the person arrived)
Date of release (the above + 60 days)
Billable days for the current month

The first is simple, the clerk will enter the current date when the person arrives.

For the second field I am using:: =SUM(H5+(60),) (H5 is todays date, and will display the results in I5). When H5 is blank, I get the " #VALUE!" error in I5? Is there a more effective function to use?

For billable days, I am using; =SUM(J2 - (H5),) (J2 is simply the last date of the month; 12/31/09, and H5 is the placement date). I want to show the number of billable days in the current month. This will be repeated on 12 sheets (one for each month).

View 10 Replies View Related

Excel 2000 :: Change Tab Colors On Spreadsheets?

Dec 27, 2011

color tabs for Excel 2000 add-on

Any freeware (or shareware if necessary) program that will allow you to change tab colors on spreadsheets in Excel 2000. Later versions do have that ability built in, but 2000 does not.

View 1 Replies View Related

Excel 2010 :: Creating A Chart With More Than 2000 Dates (each Day)

Apr 26, 2014

I am creating a chart with more than 2000 dates (each day). How can I format the axis so it only displays the 1st day of each quarter (01/01/2010, 01/04/2010, 01/07/2010...).

At the moment I cannot format the axis and minor/major units remain numbers.

I am using Excel 2010 and European date format.

View 2 Replies View Related

Excel 2000 :: Find Duplicates Then Calculating Dates?

Aug 28, 2013

I record all jobs that come into my department. Column A contains the Job reference. Column B Contains the date that the job arrived and Column C contains the date that the job was complete.

The job can be split into several sections and can arrive on different days and the sections can be completed in different days.

I am looking to create a table that will show how long the complete job took to complete, so I am looking for the earliest date and the latest date for specific job reference numbers.

An example of my data is:

Column A Column B Column C
Ref No Date In Date Out
2013-0055 01/03/2013 25/03/2013
2013-0061 01/03/2013 03/03/2013
2013-0061 02/03/2013 20/03/2013
2013-0055 07/03/2013 28/03/2013
2013-0061 08/03/2013 19/03/2013

From the above data I am looking to create a table that will show

Ref No First Date Last Date Number of Days
2013-0055 01/03/2013 28/03/2013 28
2013-0061 01/03/2013 20/03/2013 20

I am using Excel 2000.

View 4 Replies View Related

Macro Works In 97 & 2000 But Not 2003

Mar 15, 2007

I convert text file into Excel. Then what I want is to look in column C for cell value “UNT:” (it is chopped word account: ) and copy value what is in the same row next column D into column K.

Then in column K copy down the value until next not empty cell.

My problem is that it works on Excel 97 and 200 but 2003 doesn’t work.

View 9 Replies View Related

Macro In 2003 Is Not Working In 2000

Apr 25, 2008

I have constructed a macro, (with lots of help from the fine people on this site), and have distributed it to several people in the company. The macro was written in Excel 2003, and runs perfectly on all the machines running Excel 2003, but persons using Excel 2000 are getting a runtime error, variable not defined.

Is there a trick to getting a macro to run in both versions of Excel?

View 9 Replies View Related

Macro Run Faster In 2000 Than 2003

Feb 18, 2008

I have a macro which is able to run very fast in Excel 2000. Almost 5s. When i run it in Excel 2003, it takes almost 4 to 5 mins to complete. Is there any patch in 2003 i need to run the macro smoothly?

View 4 Replies View Related

Excel 2000 :: Include JavaScript Snippet When Save As Webpage?

Jul 8, 2012

I have a single spreadsheet that I save as multiple web pages [the sort and total options differ].

Is there an easy way to include a javascript snippet in the saved page without having Excel mangle the code by &ing the "<" and so on?

Excel 2000 on XP

View 1 Replies View Related

Loading Excel Range With Vba-array Blows Up In Office > 2000

Jul 18, 2008

I am using the following

xlrng.cells(5,1).resize(5,5) = myarray

If my array contains a text column with any text cell element > 900 bytes
office 2003 and greater blow up

in office 2000 it automatically truncates it without blowing up

if i write my own load loop, and load each cell individually
it works great no-poroblemo, its just extremely slow!

Is there any magic way to get this working correctly without truncation
and without blowing up?

View 9 Replies View Related

Excel 2000 :: Unable To Hide Hidden Column When Save As Webpage?

Aug 15, 2013

Currently I'm using excel 2000. Can't hide hidden column when save as webpage?

View 2 Replies View Related

Run A Macro On My Machine (Windows 2000 And Office 2003)

Jun 29, 2006

I'm trying to run a macro on my machine (Windows 2000 and Office 2003) and I keep getting an error on one method. Now I tried to run the same macro on a different machine (Windows XP and Office 2003) and it didn't error out.

Public strControlTitle As String
Public strControlTime As String
Public strControlUnit As String
Public intControlItem As Integer
Public intLastNameOnly As Integer
Public intDataType As Integer

Sub Main()
Dim strControlItem, strPageName, strValue, sigma, z95, z99 As String
Dim r, c, count, cmax, rmax, rt, ct, low, high, a, b As Integer
Dim lesscol As Integer
With ControlChartForm
.ComboBox1.AddItem ("Average Turn Around Time All Patients")....................

View 4 Replies View Related

Excel 2000 - If A1 Equal Or Less Than 1000 Multiply By B1 Otherwise Multiply By C1

Oct 30, 2013

Excel (2000), what formula would I use to accomplish the following?

If A1 equal or less than 1000 value, multiply by B1, otherwise multiply by C1.

View 9 Replies View Related

Add Ins For 2000

Mar 30, 2005

Where do i find the numbering add ins for Excel 2000? I receive a message
every time I open a document that says: I must load them for optimal
numbering and toolbar behavior. I have looked in the add ins by going to
add remove program, selecting Microsoft office, then change, then excel.
under the add ins there is nothing that says "numbering". I have also looke
on line for a down load at the Microsoft web site.

View 14 Replies View Related

Calendar Pop Up In 2000

Oct 17, 2008

I created a calendar control pop-up in Excel 2003.

To create, I did the following:

First: I went to Insert>Object>Calendar Control.

Second: I inserted following code

View 10 Replies View Related

#NAME (2000 OK 2003 NO)

Nov 23, 2006

Excel 2000 spreadsheet everything is fine.

When I open the same file in excel 2003 #NAME? Error appears.

I check Accept Labels in Formulas and it helped in some places but not everywhere.

I still have lots of NAME errors in a relatively simple spreadsheet.

I Excel 2000 everything works fine.

View 9 Replies View Related

2000 Opening Files

Mar 12, 2007

Last monday I clicked on my quick launch icon for my time card, which is in excel. It opened up, but I got an error message saying that excel had an error, send report or don't send report. Closed everthing out and clicked on the icon again, but this time excel oppend but the file did not. I get just a blank (don't know what to call it) spreadsheet. There are no cells to enter anything in. I do get the "File, Edit, View, and so on" at the top. I can click on File than Open and browes for the file and open it that way, but I can't open any Excel file by double clicking it in explorer.

View 10 Replies View Related

Delete The .xlb File In 2000

Dec 2, 2008

I have created an AddIn with code for menu buttons. When I delete the .xlb file it is replace with one about 12 KB. After some use it starts growing. One station had it to 1 meg. Could this increasing file cause problems for the code? If so, is there a way to keep it from growing?

View 5 Replies View Related

Toolbar Menu (2000)

Jul 2, 2009

I coppied this code from: Modified it to show menus but how to add sub menus? (This is the only code I found that works on Excel 2000, so far).

View 4 Replies View Related

2000 And Operating Systems

Aug 23, 2009

If I have an application developed in Excel 2000 with Vista Operating System, does it matter what operating system (XP or later) under which it runs.

View 2 Replies View Related

Autofilter 2007 Vs 2000

Sep 7, 2009

In using Autofilter on a Date column in Excel 2007 compatibility mode (Vista) and in Excel 2000 (XP), I receive different selection criteria (see pictures attached). In Excel 2007, I can select by year, by month. In Excel 2000, I am presented with all dates available in the filtered column.

I realize I can do a custom filter in Excel 2000 with a range of dates to select only the month I wish to query but this is cumbersome for the user. Is there VBA code available that will allow the same or similar selection criteria in Excel 2000 as is available in Excel 2007?

View 4 Replies View Related

Find An Average In 2000

Jun 2, 2009

I have a total in F16 that i need to find an average of.

The range is set from f4 - f15 (12 months) and need to find the running average per month. but as we only have done 5 months of the year so far that is the only average required (F16/5).

I need this to count at the end of june (F16/6) basically not counting any zero months (jul, aug, sept etc until the end of each)

View 5 Replies View Related

VBA - Using 2007 Macros In 2000

Feb 2, 2009

I have made a couple of Macros in VBA for 2007 that resize re-font etc a graph, and another one that exports te graph as an image. I want to use these macros on a few other machines but they are running older versions of Excel and i get an error when i try and use the macros.

Would someone mind taking a look and showing me how to adapt them to work in excel 2000/2003

First macro:

Attribute VB_Name = "Module11"

Option Explicit

Sub ModifyChart()
Attribute ModifyChart.VB_ProcData.VB_Invoke_Func = "u
ActiveChart.ChartArea.Width = 900
ActiveChart.ChartArea.Height = 600

ActiveChart.ChartArea.Interior.Color = RGB(233, 233, 233)
ActiveChart.PlotArea.Interior.Color = RGB(233, 233, 233)

If ActiveChart.HasLegend Then
ActiveChart.Legend.Font.Name = "Verdana"
ActiveChart.Legend.Font.Size = 16
End If..........................................

View 9 Replies View Related

2000 To 97 Conversion Issue

Apr 29, 2003

I have built a nice employee time tracking device in Excel 2000. It is pretty self explanitory ("IN" time, "OUT" time, total time, etc). What I am having problems with is the VB code that is behind the "OUT" time. In essence, once an "OUT" time is entered, the ms error message box is overwritten to ask what type of break the person took (No Lunch, 1/2 hour, 1 hour) and takes the response and implements it into the Total hours calculation. Works great in 2000, but the users are getting problems in 97. i don't have 97 and can't seem to trouble shoot it. Could some guru with 97 have a look at this and see what exactly I am missing in 97.

The code is a manipulation of Ken Getz's brilliance by Stratos. Which can be viewed at the following:

View 9 Replies View Related

Set A Tabing Order In 2000

Jun 24, 2006

Is there a way to set a tabing order in excel 2000? If so where do I find it or how do I set it up. If there isn't a way might there be a way once i create the permissions in 2003 to revert it back to 2000 and keep the same permissions.

View 9 Replies View Related

UDF Compatibility Between 2003 & 2000

Aug 17, 2006

I have an activity recording tool created in Excel 2003 which works perfectly (ish)
However when some of my colleagues use it on machines running Excel 2000 it falls over at the following definition

Dim dlgFile As FileDialog

this is part of the following sub routine

Sub doCopy()
Application.ScreenUpdating = False
Call Archive
Dim dlgFile As FileDialog
Dim rv As Long
Dim sCreated As String
Dim sClosed As String
Dim wsThis As Worksheet
Dim wbkAOM As Workbook
Dim sThisCol As String
Dim aAOMCol As String
Dim strDate As String
Dim wsCore As Worksheet
Dim wsDiverted As Worksheet
Dim iRow As Integer
Set wsThis = Application. ActiveWorkbook.ActiveSheet
Set dlgFile = Application.FileDialog(msoFileDialogFilePicker)
dlgFile.Title = "Select AOM Sheet"
dlgFile.InitialFileName = "*.xls"
rv = dlgFile.Show.......................

View 5 Replies View Related

2000 - Save Data As A Web Page

Apr 20, 2009

Using excel 2000 on windows XP (home). When saving data as a web page the grids do not show despite having the page setup "show grids" box ticked. It makes reading the file on line hard to follow.

View 2 Replies View Related

2000 Sheet Tabs Missing

Jan 21, 2010

I am pulling my hair out trying to figure this out. Any help at all is greatly appreciated. I created a spreadsheet for a friend to track his profit/loss for his business; he is not very computer literate so I created separate tabs for each month. I have no idea what he did but the horizontal scroll bar and all of the tabs are not visible, he is using excel 2000 on windows XP. Unfortunately we are not in the same area so I can’t go look at his screen. When he emailed the file back to me and I opened it, it looks fine. Also when he opens any other file it does the same thing. I have gone through all of the obvious causes, everything is correct in the tools, options.

View 8 Replies View Related

Copyrights 2005-15, All rights reserved