Search results for query: *

I know it’s an old thread, but in case anyone is still interested, epson connect does this. I have no intent to use it but just bought an ecotank printer which has this. Gavin

Hi Skip, Sorry I missed the notification of a reply. When I said "Ctrl-; works as expected" I indeed meant that there was no longer an issue. I understand everything you said. I hadn't thought to split the operation between the text entry portion and the parsing operation as I could not say I...

1st Dec but today Ctrl-; works as expected - even if I set the time zone back 12 hrs (I can't change the system date) Gavin

Pulling my hair out! Windows region settings are English UK with short and long dates as day month year. The cell format is DD-MM-YY HH:MM:SS If I click on the time at the bottom right of my desktop the calender that comes up shows 1 December. So windows knows the correct date. I am using...

Try testing for len(cell-address)=0 It can be easier to test your cf formula in a normal worksheet cell. So put that formula in a worksheet cell. If you can't see what the content of these not-blank cells is you can also put in a cell =char(my-cell). Then decide whether you want to clean up...

You have given so many of us inspiration and guidance over the years, thank you so much, Skip! Best wishes for the future. Gavona Gavin

I think the printer thing is linked to network printers and also to the application keeping track of where every page ends etc. So there are a few other options to try below. My VBA experience is limited to excel so I don't want to comment on your specific code but generally you should avoid...

Could this be to do with the printer? Try changing the active printer to "Microsoft XPS Document Writer" and switching off any settings that require Word to paginate etc. Application.ScreenUpdating = False Gavin

Thanks for the additional pointers - I'll have a play with both of your suggestions. I have it working - resolved by Skip's first response (which sort of explains my tardiness in coming back to the post!). I think I can see what you are both getting at. I used MS Query to create the SQL...

That makes total sense, I have been tweaking the source data, thanks Skip. My internet searching didn't turn up that simple fact :( [bigsmile] Gavin

I am using excel 2010 (and I have PowerQuery installed but not used in this workbook). The source data is a table in another workbook. The message I get is "Too few parameters. Expected 3." Why would it expect 3? How do I best resolve this, please? The SQL is: SELECT...

Making lots of assumptions about your sheet but hopefully it will give you an idea how to identify the issue even if you have to tweak for your circumstances. ... Copy as values to a new worksheet? -does the new sheet scroll ok? Then copy formulae and formats from the first row in the old sheet...

None at all and we do it a lot. We have some quite large shared lists (downloaded from our ERP) which are regularly updated and stored as named ranges in XLSX workbooks. Typically the required info is pulled from them using lookup functions. (End users are more comfortable with lookups than...

An non-formula alternative in case someone finds this post in the future might be to: 1. copy columns A:D to C:F 2. Select C1:F1, Insert, Shift Cells Down 3. Filter Column F within your data area to show only blank cells and delete these rows If you have lots of rows then you may be better...

Thanks Paul, Whilst I was able to figure the format codes, those links deserve more than one star! I have got it all working. Gavin

Thanks Combo. I got divertedto something else but will get back to this next week :) Gavin

I am constructing a mail merge using Word 2010 to construct an (HTML) email. The mail includes a table containing merged fields. How can I format the numbers to 2 decimal places and with thousands separators? Can Word do this or must I change numbers to formatted text in my source table. In...

Maybe this would do the trick? Depends on the structure of your sheet.Dim strCol2 As String Dim rFormula As Range Dim rDestination As Range strCol2 = InputBox("Enter Column Letter to Reformat the data", "Tell me", "A") Set rFormula = Range(strCol2 & "1") Set rDestination =...

btw, in case anyone comes back to this post. As Skip said merged cells are often problematic. I often find that Horizontal format of Centre Across Selection does the same job without causing so many issues. Gavin

This question rang bells..... Sounds as if faq707-7583 will help? Gavin