Search results for query: *

Thanks Tony - I ran it again and you are right. With a bit of adapting to my purposes it now works well! Duncan

Hi Tony thanks for your interest, but I think I now have the answer! What I was trying to do was copy the adress of a hyperlink to the adjacent cell, but as a hyperlink also. When I first tried recording the process and ran the resulting macro I got an exact copy of the copied cell rather than...

Hi Loomah and PH, I hope you guys are still there. Thanks for your previous replies - I was taken off to hospital just after and have only just returned. The info is fine but I need to maintain the address as a hyperlink, not as text only as is happening. Any Ideas? Duncan

Thanks for your reply Loomah. What is the (1) please, and where do I put the cell to copy into? (In the case you use it would be B1) Duncan

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...

Geoff That's it! I feel very stupid for not thinking of it and I'm not sure how it happened but that is the answer. Thanks a million

Hi PH I tried debugging manually but the only problem is that autofilter does not work. It has stopped being available manually as well in that file. Other files are not affected. Duncan

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

Skip, Thanks for your help - I have got it all OK now. Your comments about rows etc. were useful as well. The Oddity arose from my stupidly not arranging the column correctly, but I knew I could sort that out and did so when I thought about it a little! Thanks for your help, and for bearing with...

Skip, Sorry I had to leave yesterday before your reply arrived! Overview Summary Mar-04 Apr-04 May-04 Jun-04 PPC Value of Sales £1,619.19 SEO Value of Sales £8,484.86 Affiliate Value of Sales £405.12 PPC Traffic 5623 SEO Traffic 2571...

Thanks Skip, I just tried that on an existing chart and got a rather odd result! I'll work on it and come back if I get no joy but if I understand your reply correctly, you can vary each of the series on a chart individually? 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

I have just realised that the problem must be that I am moving it from a page (called pgRecord) to the body of the userform! How do I handle that please? 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...

Thanks a million - it works great!! Duncan

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 =...

Thanks to you both - sorry for the delay in replying, I was called away! Duncan

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...

lube8 Could you have the formatting code in the worksheet, either triggered by event, or auto-open? Duncan

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