Code:
ActiveWorkbook.RefreshAll
ActiveSheet.ListObjects("Table_SE_Query").Range.AutoFilter Field:=12, _
Criteria1:="="
ActiveWindow.ScrollColumn = 2
teambau
Last Activity: May 28 '10, 12:37 AM
Joined: May 5 '10
Location: ca us
-
MS Excel Macro: Subscript out of range (Run-time error '9')
Hi folks, I recorded a macro in Excel that copies data from one worksheet to another and then plots said data into various charts. I'm not a programmer so I'm unsure what exactly is wrong. Here is an excerpt of the macro:
... -
Jim, thanks for the tips. I will look into this. -
Run-time error 3003 - Storing Values from Form to Table
I'm encountering an error in MS Access 2007 when I try to store values from a form to a table. Here's a snippet of the VB:
...Code:Private Sub Submit_Update_Click() Dim DB As Database Dim new_comment As Recordset Set DB = CurrentDb() Set new_comment = DB.OpenRecordset("tbl_History", dbOpenDynaset) new_comment.AddNew new_comment("AWT") = AWT.Value new_comment("Issue_Criticality")
No activity results to display
Leave a comment: