Search results for query: *

Thanks for your help guys - GetRows is very helpful. I'll keep an eye on the other thread to see if anything pops up (need to work on my searching!)

Hi, Is it possible to transfer data directly from a 2 dimensional array into an Access table, and back again? I've been opening the table as a recordset and adding each row in the array individually, but this takes forever as I have to update the recordset after each record is added... Thanks...

Thanks for the feedback. I'm thinking of trying SUBTOTAL - it would limit me to only a few operators, but hopefully it should be enough to get the app working. Thanks!

Hi, I'm trying to find a function which will allow me to vary the operator which is used based on a string in another cell i.e. - formula would be along these lines =function(A2,B2,C2) where A2 and B2 are values to which some operator is to be applied and C2 is some string which defines the...

Hi, I'm trying to use the Linest function to perform linear regression on a set of data. My known ys are in one row, and there are 65 values. I'm trying to fit those values against 27 known xs (ie - an array with 27 rows and 65 columns) however, I'm getting a #ref error. The error seems to go...

Hi, I have a problem with one of my Excel workbooks. Basically, I'm trying to change the formatting on one of my charts. On one of the data series, I change the data labels so the font is bold and 8 points, the border has a shadow and they are aligned below the line. This works fine, but when I...

Thanks Lonnie, there was a division by zero lurking deep down in one of the source queries!

Hi, I'm trying to create a summary query based on another query, but when I run it I get an Overflow error. The query I am trying to summarise has five fields - Marcom_ID, Call_Date, Calls_1, Calls_2, Calls_3. This query runs fine and returns about 55,000 rows. For the summary query, I link...

It seems the issue was caused by trying to add an event procedure in a different workbook to the one which contained the code which was running. To get around this, I created a procedure to create the event procedure in the new workbook and called it Auto_Open, therefore the next time it is...

Hi Skip, Thanks for your help. I tried that method earlier, but it still crashes my system. I have a suspicion that the problem is the reference to the Visual Basic Extensibility library. The workbook with the code in it has this reference, but the workbook I'm trying to add the code to...

If anyone has any thoughts on this one I'd really appreciate hearing them...

Hi, I'm trying to add a SheetBeforeDoubleClick event procedure to the ThisWorkbook module programatically, but when I try to call the CreateEventProc method, Excel crashes immediately. I have no idea what is causing this! Here's my code: Set vbCodeMod =...

I'm using Excel 2002. I have to say, I've never had this problem before.

Hi Skip - thanks for your quick response. Unfortunately, I'm still getting the same issue. It seems as if the named ranges are invisible if the sheet where the range they're located is not active. I can't access them either through Excel's Insert - Name - Define... dialog box or through VB. One...

Hi Everyone, I'm writing a procedure to create a workbook on demand. My problem is when I try to name a dynamic range programatically. This is the code I'm using: ThisWorkbook.Names.Add Name:="ProdLines", _...

The column property is Replication ID...

I tried that originally, but it came back with an error saying it was a "Malformed GUID"

Thanks for all your help on this one, guys, I appreciate it! The variable in question is the value of a replication ID held in a text box on the frmPromoMaster. When I try the function changing it to just a normal string (and changing the data) it seems to work fine. I think I'm going to give...

Hi Daniel, I checked my references again, and I did have ADO turned off. I tried adding the DAO references, as you suggested, but it doesn't seem to be doing any good. Similar code is working for other data types, it seems the be just replication ids which cause issues. Does anyone now if there...

Hi Tiny, Thanks for the suggestion, but I'm afraid I'm still getting the same error message...