Programming

How to get source data range for each series of an active chart
Is there a way to get (for display) the source data range for each series of an active chart? I cannot find a method to provide the data range. Thanks, Alan ... 21 Jul 2008 20:17

Return ListItem via HitTest
Excel 2003 Win XP Need to get a reference to the individual ListItem object upon which the user DragDrops within a target ListView control. Private Sub ListView1_OLEDragDrop[snip] Dim LstItm As MSComctlLib.ListItem Set LstItm = Me.ListView1.HitTest(x, y) The above works however it always retur... 21 Jul 2008 19:15

Nested If/Then Help
I have a data set of three columns and 6000 rows, these columns represent the last three months of sales actuals. In each column if a sale occurred then a number is in the cell, if not then the cell is blank. In another column I would like to perform a calculation using the most recent data. So if a sale occurr... 22 Jul 2008 10:37

COlor Coding specified time frames
I am attemtpting to use validation with date function. Example: I have a booked date and a specimen date. I want the cell to turn a specific color if the booked date and specimen date is 0-1 days, another color for 2-3 days, etc. Is this possible? I can apply conditional formating to a date just one day gr... 21 Jul 2008 22:20

Excel VBA AdvancedFilter Question
I'm trying to use the AdvancedFilter option to filter some data. For selecting some search criteria and then filtering it's working fine. Here's my code for that: Sheets("PreFilter").Columns("A:B").AdvancedFilter Action:= _ xlFilterCopy, CriteriaRange:=Sheets("Criteria").Range("A2:A3"), CopyToRan... 21 Jul 2008 19:15

Excel Macro 'Sheet.Range.Value' Syntax Questions
I've got a few very basic syntax questions. On my main worksheet, I've got a list of sheet names. I've saved them as variables using the following commands: Dim ProjectSheet1 As String Dim ProjectSheet2 As String ProjectSheet1 = Sheets(1).Range("C6").Value ProjectSheet1 = Sheets(1).Range("C7").Value I'd lik... 21 Jul 2008 20:17

Excel loses mind clearing VBA global variables
I've inherited a large Excel and Access application that has been grown over time by a number of individual developers. The major issue I need to resolve is the use or abuse of global variables. This application uses VBA global variables rather than storing data on hidden worksheets. Also, all data is loaded in... 22 Jul 2008 10:37

Code not working, copy in Select Case section not copying over.
Hi friends, The code below is to copy information that matches in one sheet to another sheet. I am having problems with one area where I need it to look at criteria of days. Everything is working fine except this: Select Case Timeline Case 60 .Cells(arr(i), "H").Copy _ ... 21 Jul 2008 23:22

Printing Problem
Thanks in advance Problem: Following code would print only a header portion. This is a portion of codes that puts some data into "Statement" worksheet and print it upon different data. For each ----- Worksheets("Statement").Range("A1", "AN4").PrintOut From:=1, To:=1 Next On the other h... 21 Jul 2008 21:19

form submit
hi, i have some code that opens up a web page and fills in the user and password fields. then i have some code to submit the form. there is an OK and a CANCEL button in the internet ASP form. here is my code: .... With myDoc.getElementsByName("user")(0) ..Value = strUSERNAME End With myDoc.forms(0).... 21 Jul 2008 20:17