Recent content by Abi1

It works! And it's a much more cunning way of doing it! Thank you Geoff!

Hi, I keep getting the above error message when pasting values. What am I doing wrong? The exact situation is that I'm trying to copy individual rows of data from one workbook to another. The code looks at the source workbook, records each team number in the variable import_team (Dim as...

Yes, it works now. Thanks Andrew299!

I've got an on-open macro in my Excel workbook which is supposed to maximise Excel and maximise the workbook within Excel. Should be simple enough. My code is: Application.WindowState = xlMaximized ActiveWindow.WindowState = xlMaximized Excel maximises itself ok, but the workbook...

I did something similar to that once, with a delete then an append query to a temporary table. Abi

I've used voice recognition on a desktop, and had to upgrade from 64MB to 128MB ram to get it to run properly (IBM Viavoice). It now whizzes along with 256MB. I doubt the ipaq has enough memory to run it. For someone with Parkinsons, could they use a normal dictaphone then get something like...

The PasteSpecial function needs a range variable to operate on, so you either have to say Range("A1:B1").PasteSpecial or you can but ActiveCell.PasteSpecial. Replace your ActiveSheet.Paste line with this: ActiveCell.PasteSpecial (xlPasteValues) As for the testing whether the...

I mean more what Hasit is talking about - dynamic cross-hairs that move with the mouse pointer, and display the numeric values of x and y at that point. I don't want the actual chart to move.

Has anyone managed to add cross-hairs to an Excel chart? I mean full-sized cross-hairs that move with the mouse, not just turning the mousepointer into a cross. Thanks Abi

Make sure your If..then..else is on one line. Macros tied to buttons are fine. You'll have to have a different button for each range. The code I've written above will just look at whether the target cell in the target workbook is empty. If not, it doesn't do anything. If you want it to copy...

To get the macro to chose the list, I'd create a form so that the user can input the list to move. The code you use depends on how you've named the lists. For example, if you've given the cell at the top of the list a range name then you could select the list by using something like...

I've contacted both Avantgo and Microsoft. Needless to say neither have replied.

I'm using a Compaq Ipaq. I've just upgraded in Internet Explorer 5.5 (another program upgrade forced me to), and Avant-go sync hasn't worked since. The ActiveSync works for files, Inbox, etc, but not for Avantgo. Has anyone else experienced this, and found a solution? Thanks, Abi

How do you set a macro to run every time a database is closed? Is there a Beforeclose event as in Excel VB? Help would be much appreciated Thanks, Abi

Thanks for the replies, but I can't get either method to work! For the code method, where do I put the code? I've tried in a module in a new database, but it gives an error. The box that appears under the code as you type suggests putting As Database at the end (this gives an error too). For...