Search results for query: *

I'm having a problem changing the reference in a vlookup formula for each cycle of a For..Next loop. Current code is: ActiveCell.FormulaR1C1 = "=IF(ISNA(VLOOKUP(RC1,QryRecDetailsCalc!R2C1:R2C3,3,FALSE)),"""",VLOOKUP(RC1,QryRecDetailsCalc!R2C1:R2C3,3,FALSE))" I...

I'm trying to write a For..Next loop for a vlookup in Excel. For each loop, I want the reference area to move down a row. ie. vlookup(A1,Sheet1!A1:D1,3,False) then next loop vlookup(A1,Sheet1!A2:D2,3,false) Declaring a variable V for the reference area - just doesn't work. Any ideas...

I'm trying to highlight the range from ActiveCell to Activecell+(value in the activecell). Doesn't like: Range(ActiveCell:(ActiveCell.Offset(ActiveCell.Value,0)).select Any help, much appreciated.

In Excel, I'm trying to find a way of filtering using date variables. I have 'Startdate' as 01/03/02 and 'EndDate' as 31/03/02. I need to filter out all entries in a list between these dates but 'Criteria' within VB does not like "=>StartDate" Any help much appreciated. John

I have some code that opens up another database (reference db1) Dim appAccess As Access.Application Dim strDB As String strDB = "R:\Rad\RAD Application 97.mdb" Set appAccess = _ CreateObject("Access.Application.8") appAccess.OpenCurrentDatabase strDB This works...

I'm trying to find some code that will run a module in another database. Any ideas? many thanks

I'm trying to run an Access module from pressing a button in an Excel file. The module creates a table and then I need it to be exported to the excel file with the button. Any help would be very appreciated!!!!

I need some code that runs a module in Access then imports the resulting table into an excel file, preferably by just click a button. Any help? Thanks.

I'm trying to use a textbox on a form that brings the number of records held in an unopened query. The expression =count([QryName]) does not work. Can anyone help me? Thanks

I have a VBA code that does various editing functions over multiple worksheets. I am looking for a piece of code that displays just the opening sheet with an eggtimer instead of having the strobe effect from swapping from page to page. Any offers? Thanks.

I need somehow to export a query onto a particular sheet in an Excel workbook. This is because I want to export a different query onto a different sheet in the same workbook. I have enclosed the code so far: any help be much appreciated!!! Sub Export() DoCmd.TransferSpreadsheet acExport, 8...