Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: LGMan
  • Order by date
  1. LGMan

    VBA to Filter a PivotField

    Thanks combo, works like dream
  2. LGMan

    VBA to Filter a PivotField

    Hi, I have a PivotField(RD) which currently has 58 AlphaNumric values but I need only to filter the ones that start ‘AB’ which this week is 9 instances The total list of RD will vary each week, and new records starting ‘AB’ can appear. Is there a way Within VBA to Filter like this? I recorded...
  3. LGMan

    Pivot Tables and dates

    Hi Skip found what you mentioned thanks plus a bit more that might be handy.
  4. LGMan

    Pivot Tables and dates

    Oh wow Skip, so glad you are still here on Tektips I’ll investigate further
  5. LGMan

    Pivot Tables and dates

    Hi, not had to bother with pivot tables for years but have a requirement to display data in a pivot. One of the columns in the data is a date column, I will be summing sales with the date field running across the pivot columns. Trouble is I don’t want to see the individual dates, what I’d like...
  6. LGMan

    I'm saying mostly goodbye

    Skip, I wish you the best of luck, without doubt you have helped me no end over the last 5 years or so. It’s been a pleasure reading your many replies to tonnes and tonnes of questions on this forum. Best Regards, LGMan
  7. LGMan

    Problems with Excel attaching a jpg within a send email routine

    Hi, had to change the code, however I think my laptop may have something to do with why the original code caused intermittent failures. I've sent a run of 70 without issue. Also added an error catch incase it fails so it should try again, however this has not been tested as all my tests have...
  8. LGMan

    Problems with Excel attaching a jpg within a send email routine

    thanks Skip, I'll give that a go, its 21:29 in brixitland so I'll report back in what will be tomorrow for me :-)
  9. LGMan

    Problems with Excel attaching a jpg within a send email routine

    Hi, Skip, yep all the ranges exist on the sheet where the range of cells that are copied into a jpeg exist. I've been testing what has been suggested and stepping through the code, but it all looks to go through ok until I look at the emails and out of 38, 2 of them just had the outline of where...
  10. LGMan

    Problems with Excel attaching a jpg within a send email routine

    Hi Skip, am not sure I understand what you mean.
  11. LGMan

    Problems with Excel attaching a jpg within a send email routine

    Hi all, a co-worker has moved on and the ownership of a VBA routine that copies a range of cells with Excel and turns that range into a jpeg to added into an email has been passed to me. The routine loops through a list of managers which changes the data in the range for each new email. The...
  12. LGMan

    Stopping a worksheet change event

    Hi Combo, dont know what happened there as the range is ("A1:C" & rng) it was after midnight here in the UK though :-(
  13. LGMan

    Stopping a worksheet change event

    Thanks Skip, I was struggling with the logic as the cell was being changed so why wouldn't of the course the change event trigger. Try as I might I couldn't get a workaround to work. Your solution as ever is simple but elegant. Cheers.
  14. LGMan

    Stopping a worksheet change event

    Hi, I have a worksheet change event which works fine as is, if new data is pasted into the range. How can it be stopped if the range is cleared or deleted? Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Long Dim rng2 As Long With ActiveSheet rng =...
  15. LGMan

    Checking that an external file is open

    Thanks Combo, it works like I hoped it achieve in the first place! Skip, I take yout point that in this ocassion I would be able to use the day and use it in the filename, but there are temporary files that I download from the company IntranNet and they sometimes for reasons unknown have a...
  16. LGMan

    Checking that an external file is open

    Hi Skip, I had to type this out manually, the code in my workbook runs as all the names are correct
  17. LGMan

    Checking that an external file is open

    Hi, I get sent a file each day called 'Daily_Sales_ddmmyy'.xlsb, so todays was called Daily_Sales_140218.xlsb The code below loops though ther open workbooks until it finds the Daily_Sales file, I know to have that file open before I trigger the Procedure which pulls this file into my Master...
  18. LGMan

    Calculation mode linked to combo box (form control)

    Doh, found it :-)
  19. LGMan

    Calculation mode linked to combo box (form control)

    Hi, i’ve built a summary worksheet that now has more cells with formulas than I had originally planned. I have an combo box (form control) which a user chooses a value from a list of cities, The selection is linked to a helper sheet which works out the stores within the selected city, which are...
  20. LGMan

    Removing a variable number of columns

    Hi Skip, you are a true legend on this forum. The code works a treat and will save me the agro of the manual effort each day, and so much easier for one of my co-workers who is my deignated cover. Your code is also great for me to learn from. Many Thanks LG

Part and Inventory Search

Back
Top