Search results for query: *

Hi xwb, Thanks for your reply. The focus seems ok, I copy and then want to do several repeated pastes down a page, and the data is lost after the first paste. To do what I want I have to repeatedly copy and paste. Other times I works fine!

Hi, I find lately that Ctrl-V (Paste) sometimes does not hold for multiple pastes (repeating Ctrl-V without a Copy each time). Sometimes it works perfectly, then sometimes I have to do a Ctrl-C (Copy) for each paste. Any similar experiences, or even better, any known solutions! Thanks in...

Hi MakeItSo, Did the job! Great! Many thanks

Hi MakeItSo, Thanks for your quick reply. Will check it out and let you know how I go. Cheers,Peter Moran

Hi, I have this macro in Excel to just display *.csv files in the Open Window: Sub CSVOpen() ' ' CSVOpen Macro to Open Window for *.csv files in dir "Super" ' Dim myFileName As Variant Dim Wkbk As Workbook ChDir "C:\Users\Peter\Documents\Super" myFileName =...

Hi combo, Thanks! Good info, so looks like I will have to have separate macros or replace the File Open command with my own work to get what I want. In Excel I can't get all the files I want to be displayed together, and in Word there are often too many files displayed, many of which I don't...

Hi, In Excel 16 (at least) I would like to include "*.csv" in the All Excel Files option when opening files. Files I have downloaded as csv's from the internet just don't get displayed and there seems no obvious way to amend this. Maybe I should put it on the Microsoft Excel mod requests -...

Hi Andrzejek Thanks for your reply. The fiddling is incidental, Mainly I wanted to know how to repeatedly Find and then run some code until the end of the document. My example showed one instance of what I wanted repeated until the end of the document. Peter Moran

Hi macropod, Many thanks! Will have to check out wildcard Find & Replace in detail. Not one of my strengths! I did not realise it was so powerful. Will check it out today. Also have a STAR! Peter Moran

Hi Andrzejek, Thanks for your reply. I don't understand what you have done by removing the code I need to perform every time I find the word "Singles" in the document. There may be 50 "Singles" in the document and I want to perform this code every time "Singles" is found until the end of the...

Hi macropod, Thanks for your query. This is what the 'fiddling" does: It takes text downloaded from the web: Women’s Singles - Quarterfinals - 1h11 S. Stephens (7) 1 4 J. Konta (26) 6 6 Men’s Singles - Quarterfinals - 1h51 K. Nishikori (7) 1 1 3 R. Nadal (2) 6 6 6 for all matches on a day at...

Hi, I have this macro I recorded to do some fiddling with subsequent lines every time it finds "Singles". I want this to be repeated until the end of the document, which I can't seem to work out after some investigation. Here is the macro: Sub FrOpenSinglesLines() ' FrOpenSinglesLines Macro...

Hi Paul, Many thanks, I found a few extra variants in my processing, but basically inline with your thoughts. Peter Moran

Hi strongm, Many thanks, got me going and with a little perseverence found that the text I needed was "^13<[A-Z]{2,12}> " Great work! Peter Moran

Hi, I am copying results from the French Open Tennis. This is what I get for each match in Word after I have pasted from the website: Men’s Singles - First Round Court Suzanne-Lenglen - 2h10 FABBIANO T.Fabbiano 3 5 1 - - CILIC M.Cilic (11) 6 7 6 - - Can I code a Find & Replace that will...

Hi Skip and any other Readers, Thanks for your Nuances! Please tell me then why the formula works for any other value than "" - if I change it to a space " " or any other value it works perfectly as I would expect. I don't intrinsically understand why "" should be any different to "a" or "b"...

Hi, I have a formula in B1 which says: =IF(A1="x","","x") Now I would assume that if A1 is "x" then B1 would be blank - Not So! If I use F5 Special and select Blanks on this cell (B1), it does not show as a Blank even though it has a length of 0! However if I delete the formula, it does...

Thanks Paul, Very Good! I live and learn. Peter Moran

Hi, Thanks PHV Got it this time! Peter Moran

Thanks Tony and PHV, Tony, I do not know and could not find the syntax in that context to have the Field Selected! I thought PHV had the solution until I entered it and found the "Range" after "Add" was highlighted with the error "Unexpected end of statement"! Any chance of an update. Peter...