Search results for query: *

Hi, Can anyone help with this - I'm completely out of my depth! I've managed to create an email with a form on it. I know it needs amending, but haven't got a clue what to do. I've been reading past treads, but got nowhere. What exactly do I need to add and where. Please help "<FORM...

Hi, I've just started using some code from the Ron DeBruin website to send workbooks to various people. See the code below. However, what extra bit of code would I need to add other files that would be listed in column J. Also what adjustments need to be made to send the emails one at a time...

Hi There, Can anyone help me with some code to perform an autofilter? I'm trying to filter all items in a column that are greater or less than the first 2 characters in cell e2. I've tried the following but it won't work! Selection.AutoFilter Field:=7, Criteria1:=">left(e2,2)"...

Hi, I have some code that prints from a excel pivot table to create and save as a mdi file. The code can loop upto 60 times creating 60 files. However when it creates the mdi files they are left open and no more can be created when the number of mdi files reaches 10. I'm hoping there is a...

Hi, I have some code that I been using to print hard copies from Pivot Tables. I would now like to print the file as a 'Microsoft Office Document Imaging File'. However I would like some VB code that would automatical give the file save as name. The file name is to be the first 4 characters...

Hello, Got a problem with page breaks on pivot tables. I've set 1 of the data fields to insert a break where the data changes. The trouble comes when I run a macro that changes what is shown in the field. Some how it is remembering where some of the original page breaks were. The only way I...

Hi there, Does anybody know why Pivot tables won't show any text passed 255 characters Example: I have this in a cell: Steel; electrically operated security roller shutter doors; Kirkcraig Limited or other equal and approved; standard perforated roller shutter doors, boxes with integral...

I really can't get my head round inserting formula's! Can anybody show me the way with this one: [h3].Formula = &quot;=Round(Subtotal(9,BoQ!m3:m65536)-(SumIf(f4:f65536),&quot;&quot;>0&quot;&quot;,(f4:f65536),2)&quot; Thanks, Andrew [afro]

Hello, Is there a way to replace this character &quot;~&quot;! I can't get rid of it in my excel workbook unless I manually delete each one! Thanks, Andrew [afro]

Hi, I've a bit of code that i'm tidying up and been told that Copy Destination: might be a way to speed thing up slightly, rather than Copy/paste etc. However, using the Copy Destination: routine I copy the format aswell as the values! Can I change the code to just paste the values? Cheers...

Hi I've taken an old workbook that had a Data Field call &quot;Sub Ref&quot; the data in the old workbook contain values from 01 to 36. My new workbook contains values 01 to 34 in this field. The trouble is that when a code is run to 'shows all' in this field it doesn't work because it as...

Hello, I recently wrote a bit of code to format a Pivot Table, because every time I changed a Field the formatting changed (I even had the correct boxes check so this would happen , but it did). Anyway the trouble is the code took ages (for what it was doing). Simple changing borders...

Hello, I'm trying to automate a Text to Column routine, but can quiet manage. The trouble is as follows. The column in question is B and generally the text is a number followed by a letter ie 1A, 2A, 10A, and I want the number to remain in B and the letter to go to C. If I do it manually it...

Hello, It must be something simple, but I can find it - anyway every time I Refresh the data I lose my formatting. I've trying checking/unchecking various Table options, but with had no luck! Any ideas, Andrew [afro]

Hello, I've just started using Pivot Tables for the first time and I'm sure I'm on the brink of saving a lot of time, but I just can manage to do something. What I have is a worksheet: Column A is Page Refs ie 02/01, 02/02, 02/03 etc Column B is Item Refs ie A, B, C, D and so on Column C is...

Hello, Would anyone please tell me where I'm going wrong with the bits of code below: [monkey] [E2].FormulaArray = &quot;=SUM(if(B2 <> B1, D2, E1& &quot; &quot; & D2))&quot; [F2].FormulaArray = &quot;=SUM(if(a2 <> a3, &quot;1&quot;, &quot;0&quot;))&quot; Thanks in advance! Andrew [afro]

Hello, Could anyone tell me if there's a way of finding all IBM characters ie. ², °, `, ½, ¼, etc.... and replacing them with nothing. Thanks, Andrew [afro]

Hello, I have been sent a disk, but I need to fit it into a workbook of my own. The trouble with the disk I've been sent is that text in column B that should be all in one row as been spread over a number of rows. There is however column [A:A] that has numbers within it. These number indicate...

Hello, I'm trying to compact a workbook and the codes within it, but can't write the following in VB. I would like a code to say that Sheet &quot;Material&quot; cell j1 'Value' is equal to Subtotal(9,BoQ!O3:O65000).Formula Any ideas? And..... I would also like to know how to write the...

Hello, I have the bit of code below that takes quite a while to complete, so I'm trying to speed it up! [pc1] The code loops from row 2 through to row 820, but it could skip certain rows if the row value in say column Z equalled 0. Is this possible? Code: Sheets(&quot;Material&quot;).Select...