Recent content by PWD

OK, I've got the allocation of the names from cells in Column "B" to a standard TextBox. And I can apply some logic to extract the correct data. Many thanks, D€$

Good afternoon, I have a Pivot Table that is refreshed from a weekly set of data. One of the row fields is the Cancer Site, as below. I have added a button (both "Text Box" allocated to a macro, which works & "ActiveX Text Box" for testing this) for each site and have just put together some...

Hi strongm, well, there will be about 5 different conditions for shading the cells so I thought I'd just build up several processes in code. I presume that you are talking about just shading from within Excel? Many thanks, D€$

Good afternoon, I'm just trying to start something really simple but, using this macro, Excel stops responding for the longest time. I'm fairly confident that it's not the work's network, although that could never be discounted, and I just can't see that there's anything here that would cause...

Thanks Mike, that worked. It also seems to have done it for my other recent post! [dazed] Many thanks, D€$

Good afternoon, I obviously hadn't posted here for a while but when i did, a couple of weeks ago, I noticed that my posts don't now have the red tick against them and aren't included in the list if I choose "Marked Threads First" as the Thread Order. Is this a new 'feature'? Have I not done...

Well I'll be... I almost spotted that as I thought it looked a bit odd on my screen but I, foolishly, didn't peer closer!! Works the way that I had hoped it would!! Many thanks, D€$

Hi dhookom, I get the error message "The expression you entered has an invalid string. A string can be up to 2048 characters long, including opening and closing quotation marks." Hi Andrzejek, well both in a way as it depends on what I'm trying to find out because referrals that are coded...

Thanks Combo, it just strikes me as REALLY strange that I managed to cross the x & y co-ordinates and achieve what I wanted earlier in the week - although I'll admit that I probably put this in there, did something, moved something somewhere else and Heaven knows what!! I'm finishing for the...

Pivot Filter. Many thanks, D€$https://files.engineering.com/getfile.aspx?folder=5dff302c-eece-4af8-a394-83390d3ddd07&file=20200507_Pivot_Filter.jpg

Just another anomaly, is that I changed "General Medical Practitioner" to "G.P." in the data but the Pivot Filter still offers that as an option. I've attached a couple of screenshots to show what I mean. Many thanks...

Good morning, I hope this is me being really, REALLY thick! I'm trying to limit the output in a Pivot Table to values greater than n. The attached workbook is just a model of a much larger workbook that I created earlier this week where I was able to use the Value Field filtered 'Greater...

Good afternoon, I use Public Function, and I also use aliases, What I'd like to be able to do is to combine the two, Am I just being too ambitious, or is it just basic stupidity?? [bigsmile] Many thanks, D€$

Thank you combo. CHRISTMAS DAY!?!?!? Ha ha! [smile2] I had a suspicion that 'Value' was "better". It's only a small bit of code so I've amended all to 'Value2'. Many thanks, D€$

Good morning and Merry Christmas Eve. Just asking myself the question as to which might be more efficient than the other, a or b. And do I need the .Value? a) Sheets("Data").Range("C" & d).Value = Sheets("Somerset").Range("A" & r) b) Sheets("Somerset").Range("A" & r).Copy...