Search results for query: *

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

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

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

Doh, found it :-)

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

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