Search results for query: *

Hello All, I need to copy lists of hyperlinks to the adjacent cells, but as the URL addresses. When I use the macro recorder there is no difference between copying the activecell, and copying the Hyperlink - which is what I need and which can be done manually. This means that running the macro...

Hello all, This morning when I ran a routine which I use several times a day, I did not get the expected result. The reason turns out to be that I can no longer use the autofilter in Excel. What is wrong and how do I fix it Please. Duncan

This is not really a VBA question, but you guys seem to have a knowledge of everything! I need to create a chart with a stacked column on one axis, and a line on a second axis. I seem to be able to create most things but not this. Is it possible? Duncan

Hi all, I'm having problems moving things when a form re-sizes. For example, I have a button called imgInHelp. The new position for it is at 700 left, and 310 from the top from a starting place of 384 left, 294 from the top. The code I have used is below and causes the button to disappear...

Hi All, I hope someone out there can help! I am trying to use a worksheet function (VLookup in this case), in a form code. I get an error 1004 and it shows my named range (Restrictions) as being "empty"! What am I doing wrong please? txtName =...

Hi all, I am trying to clean up some macros by removing all the "select"'s as explained by Skip. I have succeeded in speeding up a lot of processes but am having trouble with copying the result of formulas as a value. I can use the following code to copy a variable length column, but...

This is not strictly necessarily a VBA problem, but how can I import data by query to Ecxel and keep the hyperlinks? Duncan

I often have lists in excel which contain duplicate entries. Untill now I have been sorting the list alphabetically and then running the following code but it is slow slow slow. There must be a better way, please? Range("A3").Select Do Until ActiveCell = "" Do...

Hello all, I have an application which produces lists of various lengths in excel. As each new entry is generated by the macro it should be entered under the last in a column. How please! Duncan

I frequently produce lists which then need pruning according to adjacent information and would like to know the quickest and most efficient way of doing this with VBA. For example I may have a column of 6000 entries in column A, and must remove all entries next to a "1" in column B. At...

I have a macro which having done it's job must save the file it has been working on as the same name and in the same location as it was before. At present it interrupts itself to ask if I want to replace the existing file. Is there a way to write something into the macro to do this automatically?

Dawnsie asked this on another thread and I was waiting for a new thread so I could benefit too! "Can anyone tell me where to find good examples on filtering using VB. I have a worksheet, where the user selects an item from a combobox and based on the selection, I need to filter the data...