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!

Recent content by PWD

  1. PWD

    Good afternoon, I have a Pivot Tabl

    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€$
  2. PWD

    Good afternoon, I have a Pivot Tabl

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

    Excel Not Responding

    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€$
  4. PWD

    Excel Not Responding

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

    "Marked Threads"

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

    "Marked Threads"

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

    Access 2019 IIF + Public Function

    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€$
  8. PWD

    Access 2019 IIF + Public Function

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

    Excel 2019 Pivot

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

    Excel 2019 Pivot

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

    Excel 2019 Pivot

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

    Excel 2019 Pivot

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

    Access 2019 IIF + Public Function

    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€$
  14. PWD

    Range()=OtherRange() vs .Copy Destination:=

    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€$
  15. PWD

    Range()=OtherRange() vs .Copy Destination:=

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

Part and Inventory Search

Back
Top