Recent content by LGMan

Thanks combo, works like dream

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...

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

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

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...

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

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...

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 :-)

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...

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

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...

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

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.

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 =...

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...