Programming

Accessing Autofilter Lists
Is there a way (programmatically) to access the drop down lists that are created for each column when autofiltering is turned on? I took a quick look at the Autofilter object of a worksheet that has autofilter turned on, but had no luck finding anything that looked like a collection of lists. Thanks, Eric ... 26 Feb 2010 15:22

Printing App
I have a spreadsheet that, when I go to print it, increases a particular cell's value by one. This works great for printing one copy. I need it to do this for each copy printed. Ideally, I would like an InputBox prompting the user to enter the number of desired copies, and it prints a page with the increased va... 26 Feb 2010 14:14

Sort function
Hi, anyone know how to call the Sort Dialog box with a macro? Tks ... 26 Feb 2010 13:06

#VALUE ERROR
Why am I getting a #Value error with this formula: IF(OR(H22>0,F22>0),F22+H22,0) where F22=1 and H22=blank ... 26 Feb 2010 13:06

Macro/VBA to loop through list of values and output row- Help
Mike, Many thanks for the prompt response but this isn't quite all that I need. This does return the smallest distance from a range, but what I need to do is output (i.e. Copy and move the row with the lowest distance value, to another sheet) Basically, I need a new sheet (created from this one) which only s... 27 Feb 2010 14:22

Data Connection: Access Query to Excel How to get rid of heade
Thank you Arjen and Eric. I had time enough to go ahead and change the properties as Eric suggested but thank you both. "arjen van der wal" wrote: It depends on how you setup the data connection. If you're doing it in VBA using ADO and a reference to the query, the default is to not import t... 26 Feb 2010 11:57

VB: Convert rectangular clusters of # within field: FindNext, Find
I am having trouble with a script that keeps hanging and I don't know how to debug it. Its supposed to go through and search for a rectangular array of numbers ," 2", within a field of 0, and convert the end columns of that rectangular array to 0 and the bottom left and right values to 1. See the example. The ... 26 Feb 2010 11:57

mouse pointer to be focused on userform command button upon opening
I am opening up a userform and I want the mouse pointer to be focused on the command button I have so the user can quickly click it instead of having to move the mouse and find the command button on the form. Private Sub UserForm_activate() TextBox1.Value = ActiveCell.Value CommandButton1.SetFocus commandbutton... 26 Feb 2010 10:47

Upload file to SharePoint from machine with CAC
I'm looking for macro functions to upload and download files to SharePoint file sharing site - and I'm running a gov computer with a CAC card, so I don't use user login and passwords to access the SharePoint site I found this code, but is doesn't work: Function WebUploadFile(file, url, user, pass) Dim objXM... 26 Feb 2010 09:40

Side Filter
Want to filter data columnwise i.e from Column A1 With Rdgs. Sudipta ... 26 Feb 2010 09:40