Search results

I am at a loss as to why this code sometimes fail. The code access another system at work. It is able to do this but my problem seems to be on the lines of code that are . it does not always fail and I'm sure it sometimes moves an email to the same persons folder that it has failed on once...

arnelgp, I have found the control panel but there is no backup and restore option. There is system and security, network and internet, hardware and sound, programs, user accounts and family safety, appearance and personalisation, clock language and region and lastly ease of access smiler44

My laptop came with windows 8 pre loaded. I have decided I want to create a set of back installation discs so I can reinstall windows on to my lap top should the need arise. I have no idea how to, please can you advise? thanks smiler44

I have searched high and low on the internet on how to find my Microsoft outlook 2007 pst file. It seems my laptop running windows 8 has not stored the file in any of the given locations or if it has, the lap top has hidden it. GGGGGRRRRRRR. I have done a search for *.pst, no results I...

Bob, I think so. I'm calling a sub routine that is part of a userform from a sub routine that is in an ordinary module. I could possibly move the routine from the userform to an ordinary module but as I have solved the problem, no need. smiler44

A search via Google today gave me the answer. Instead of call nexttwenty it needs to be call userform1.nexttwenty. I'm surprised I have never had this problem before smiler44

err, neither, don't know how can you tell me please? thanks smiler44

unable to call a sub in a module [solved] I have a userform with a command button on it. The code associated with the commandbutton is call nexttwenty. The sub nexttwenty is in a module. I have tried sub nexttwenty () and public sub nexttwenty() but on the line call nexttwenty I'm getting a...

RX_ my second post does the job but be warned, it's not a do until loop, just a loop so only run it by the f8 key. smiler44

got it. Sub Macro3() Dim a As Integer ActiveSheet.OptionButtons.Add(100.3, 200.4, 8.5, 17.25).Select '100 across 200 down 8 width a = 225.4 Do ActiveSheet.OptionButtons.Add(100.3, a, 8.5, 17.25).Select '100 across 200 down 8 width Selection.Characters.Text = "" a = a...

merry christmas. I want to add say 20 option buttons but to make sure they are the same size and all in line and so I can do this in future, I want to use a macro to a create the buttons and position then. I can create 1 button using [code ActiveSheet.OptionButtons.Add(100.3, 200.4, 8.5...

I have received a spread sheet with an auto filter already attached and filtered. I now want to add another column to the auto filter but do not want to remove the existing auto filter, as I don't know what the filter criteria is. I have some code that works out the existing auto filter...

Brian, thank you yes I think you are right. if I can go from folder to folder I may be able to adapt this code. The path will be a variable where below it has been hard coded [code] 'To delete all the Word documents in a given directory, leaving other files 'alone: Dim MyFile As String...

When I first read your reply I had no idea how to go about the task and so had not written any code. Here I am 5 minutes later and I have an idea how to make the macro "run" the once. I have not created the code but that's "easy" but here is my idea. I wi try to get this to work on the my...

A search of the internet did not lead me anywhere so I don't know if this is possible. I want to run a macro from a workbook called "appt". I want the macro to find all other workbooks in the My Documents directory or sub directories called "appt" or have "appt" in their name and kill them...

ok RX_ thanks. I remed the line where it mentions about 2010 and it worked with more than 2 filters. I have Excel 2007 and so had left it in. Forums, the internet, fantastic when used appropriately smiler44

Rx- 1. Take off filter 2. Making changes to the underlying data 3. Reapplying the filter I think the code I found might work for me. If the filter is set to only show 1 or 2 things it worked. when the filter was set to show 3 items it failed. I think it may just need some tweeking to be...

the code in post 2 works if only 1 or 2 things had been selected by the filter but fails if 3 things were selected. i'll have a play tomorrow to see what needs changing smiler44

wow I think I found an answer of sorts on the internet. this does not tell me what the filter is set to...well it may if I play with it but it stores the filter criteria and then re-applies the filter Sub ReDoAutoFilter() Dim w As Worksheet Dim filterArray() Dim...

I have a spread sheet that requires me to unfilter it, do some odds and sods and then rapply the filter. Please can you help me with a macro/solution to work out what the filter criteria has been set to before I unfilter the spread sheet? I don't even know where to start thanks smiler44