Stack Overflow
Stack Overflow

Questions tagged [excel-2000]

Excel 2000 is one of the releases of Microsoft's Excel. It introduced a minor upgrade to the notepad. The Office Assistant was also made less intrusive.

23 questions
0
votes
1 answer

How to specify the sheet a worksheet function should use via a range object?

I have some code that searches a column of values in sheet(3) in the format of a string "value1 - value 2" value2 is the first value in a column in sheet(2) and value1 is a value in the same column, in a cell further down the sheet. The setup I have…
A Francis
  • 5
  • 3
0
votes
1 answer

Excel 100 VBA sets Condtional Formatting but results incorrect

I need to change a large amount of conditional formatting so I am writing a VBA subroutine. The following code sets the conditional format but the results are incorrect. By that I mean I go to the sheet and I see the conditional formatting is…
RoseAb
  • 133
  • 1
  • 5
0
votes
4 answers

Predict text wrapping in cell

The problem: I use VBA to populate MS Excel 2000 cells with text. The column has a fixed width (should not be changed due to layout) and the wordwrap property is set to true so the text wraps over multiple lines if wider than the…
Zen
  • 1,928
  • 3
  • 12
  • 17
0
votes
1 answer

What .TXT representation of linebreaks within cells will be correctly imported?

When I have a line break like this (created by my program, or as in this example by Excel itself): the Excel import wizard misinterprets it like this: How can I avoid this failure? The advice in Importing CSV with line breaks in Excel 2007 did not…
ChrisJJ
  • 2,191
  • 1
  • 25
  • 38
0
votes
1 answer

Is it possible automatically to protect a sheet when an error occurs?

I have tried using Goto on error, but it seems to skip this even when an error occurs, or do it even though an error has not occurred depending where I place it in the script. The runtime error occurred in this line of code: …
user1545643
  • 313
  • 1
  • 4
  • 10
0
votes
2 answers

Error 1004 when inserting lookup formula

I've got the following code to look up the date at which a value occurs in a separate sheet in Excel 2000: sSheet.Range(dateColumn & pRow) = _ "=lookup(" & valColumn & pRow & ";'" & _ iSheet.Name & "'!" & tColumn & firstRow & ":" &…
l0b0
  • 55,365
  • 30
  • 138
  • 223
-1
votes
1 answer

Data shows only as zeros on chart

I have an excel sheet with data in it: That drives a chart, but the chart only shows 0 as data: Each of my cell is a formula. I tried to write a value in a cell and it shows in the chart I tried to copy the data and paste values, but it doesn't…
Olivier
  • 309
  • 2
  • 8
  • 22
-1
votes
2 answers

Excel: Pivot chart. How to exclude totals > 1?

I'm using excel 2000. I have a pivot table which looks like this Color Total Blue 2 Green 1 Yellow 6 Black 7 How can setup the pivot chart so it excludes at values > 1? I need to be able to do this without simply copying the data from the…
totalitarian
  • 3,606
  • 6
  • 32
  • 55
1
2