+ Reply to Thread
Results 1 to 152 of 152

"I need a macro that is so simple it could be written with the macro recorder...."

  1. #1
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    "I need a macro that is so simple it could be written with the macro recorder...."

    "but I'm too lazy to use it."

    Seeing more and more of these lately. This thread is my vent at lazy gits who want their work done for them with no brain engagement required. If you want to learn how to code VBA I'm more than happy to help, anyone who shares my love of logic loops and other geeky things is more than welcome to pick my brains. However, if you want things done for you with no effort on your part then......hire a VBA developer. I'm a VBA developer and my daily rate is around £350. Hint frikkin hint.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Heh. 30 something views, half a dozen new stars added to my rep with comments like "Bravo" and "Amen"......but no posts in the thread?

    It's getting worse ya know.....

    http://www.excelforum.com/showthread.php?t=1097500
    http://www.excelforum.com/showthread.php?t=1097493

    Actually, I could paste in links to threads that start with "I want" from now until sunday....

    Why do these people seem to think this forum is where developers hand out solutions for free? Why does no-one tell them to bugger off and speak to their finance dept for a budget? Why do some people actually reply to these lazy cheapskate morons? Why do so many people think they can get an easy solution without having to learn anything?

  3. #3
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    P.S. It is becoming more and more difficult to resist the urge to respond to every "I want" thread with a link to the commercial services forum. I may need to take a break from the forum for a while....

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    It irks me too, but I simply don't bother helping (unless it's a question that piques my interest), I think it's because the type of users who post on these forums generally have very little idea how much work is involved or even where to start - it's a general office forum it's not Stack Overflow, there's no requirement to try yourself or show what you've done, if you don't like it move along; There are threads that I won't even look at based on the title - pretty much the threads that are simply "GIV ME DA CODEZ", you get the hang of spotting these a mile off.

    You'll also come across people who post frequently that I'm pretty sure offer their services on online sites, "sort my spreadsheet for a fiver", freelancer etc without actually having the knowledge to do so, if you want to wind yourself up a bit more take a look here: http://www.excelforum.com/search.php...vBForum_Thread

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by BellyGas View Post
    P.S. It is becoming more and more difficult to resist the urge to respond to every "I want" thread with a link to the commercial services forum. I may need to take a break from the forum for a while....
    Then don't, simply don't reply

  6. #6
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    ..., if you want to wind yourself up a bit more take a look here: http://www.excelforum.com/search.php...vBForum_Thread
    At least he "stays real".....

    Quote Originally Posted by Kyle123 View Post
    .......You'll also come across people who post frequently that I'm pretty sure offer their services on online sites, "sort my spreadsheet for a fiver", freelancer etc ......
    .
    . I expect many people register with a new made up name and e-mail address every time they want a question answered and so avoid people like you "sussing them out".. Not sure how true that is here, ( haven’t checked out the statistics of the “one Thread poster members”.. ) but at another Forum I am in that accounts for well over half of the Members. It ‘aint allowed but i expect a “Blind Eye” is turned to get the member quota up....

    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  7. #7
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by BellyGas View Post
    P.S. It is becoming more and more difficult to resist the urge to respond to every "I want" thread with a link to the commercial services forum. I may need to take a break from the forum for a while....
    Hi,
    . I actually fully agree with your sentiments, - after about a year here and at other forums learning VBA with about 2000 posts in Total, well over half answering rather than asking for help..( often even answering my own, at least partly!! ) ) - . I t gets to the point that when / If you are not learning too much more, than it can get a bit frustrating by the Threads of the type you were moaning about. For that, ( and for reasons of needing to concentrate on my own project), I am reducing my forum activity considerably now..
    . What is very frustrating as well is that when, as I am, still inexperienced, it is often only the less technically challenging but time consuming Threads that are left to answer as the very experienced members here snap up the rest with a speed that amazes me. – For every Thread I ever answered, I had a about 2 almost finished which I give up on as a Profi comes in with a much better solution.
    . I was wondering if there is some way to know if an OP is getting “special treatment” as a result of paying, or of it is possible to know when a pro has an unanswered Thread well in Grip so that I do not waste my attempting an answer??
    . Having said that, the Threads I most learnt from were those with lots of different solutions, especially when one solution did came from me ( when my attempt was not dismal enough for me to submit it ! ), - It is a great motivation to see and learn from how a Profi does it better, once you have struggled with it yourself...

    ...........................
    . It is certainly a very debatable issue you have raised.
    .
    Alan


    . P.s – the last thread you criticised from danfullwood, is exactly the sort of Thread I have usually been able to / left to answer in the past. Except mostly they were considerably bigger and more complicated!!!, and I had a big struggle initially to get the OP to produce reduced sample data as danfullwood has already done. So I may be tempted to have a go at that one, as a “quicky” ( relatively speaking for the Threads I have answered of that nature!!)...
    ....You did me a favour... As you replied it is not shown as an unanswered thread, so A profi will not snap it it up away from me!!!... It is a Funny World!!!!!
    . P. P.s . I wish i could earn £350 a Day from computing. I am working privately on zero budget on an important personal project. I actually find VBA programming fun sometimes. Never occurred to me that one could get paid so much for doing it !!!

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by BellyGas View Post
    Why do these people seem to think this forum is where developers hand out solutions for free?
    Pretty much because it is forum where members (developers or not) hand out solutions for free

    Nobody is obligated to respond to any thread from any member here, we all do so because we want to. I am sure most members here have come across a thread that has "pushed their button", and the advice to them is always - if you dont like it, dont reply/respond, just move on the next thread where, perhaps, your help will be more appreciared.

    This rant (and I mean that in a good way) raises it's head periodically - you are not the 1st, nor will you be the last -, and it can be good to let off a bit of steam now and then.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by BellyGas View Post
    P.S. It is becoming more and more difficult to resist the urge to respond to every "I want" thread with a link to the commercial services forum. I may need to take a break from the forum for a while....
    With only 69 posts, leaving would hardly be taking a break?

  10. #10
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2013
    Posts
    1,416

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by FDibbins View Post
    With only 69 posts, leaving would hardly be taking a break?
    Oh snap!


    This made me wonder - what do the more common posters on here do for a living?? I've literally built my current job from cruising forums like this - answering other peoples questions helps LOADS.

    First, comparing your solutions to those of the page-1 members (and others, but you know... the real gurus...) is great for improving your standard methods, and making sure you don't get so narrow minded that you miss something worth knowing.

    BUT, many, many times someone has asked a question that leads me to figure out something I didn't know was possible - which I immediately apply to something sitting on the back burner at work.

    Seriously - single phrases uttered here have led to complete breakthroughs in projects in my real life....


    ---
    Yes OP - I feel your pain - why can't the whole world just be competent, hard working, ego-checked, code monkeys with a natural love of all things logical? I guess it's just not meant to be...
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  11. #11
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by GeneralDisarray View Post
    what do the more common posters on here do for a living??
    I'm "semi-retired".

    Worked at a plant on Neville Island. Worked as a quality control lab tech where we used spreadsheets extensively. This is where I learned most of my formula skills.

    Later worked as a shift supervisor where we used spreadsheets mostly for stuff like inventory control and making employee schedules.

    I was just randomly surfing the web one day (many years ago) and landed on a Microsoft help forum. I've been very active in various Excel help forums ever since.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  12. #12
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2013
    Posts
    1,416

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I guess I should answer my own question: I work in oil-field service in the USA - operations side of things.

    My work is focused on connecting SQL and Excel to handle daily reports from field employees, and also to get data from SQL to Excel for management type reports. Spend most of my time in VBA editor and the Sql-Server-Management-Studio.

  13. #13
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    . I am not really a common poster, at least not in this Forum. Just learning VBA ( and computing for the first time!! ) for a personal project since about a year or two.

  14. #14
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    GD and Tony, you guys may be neighbours? Im not that far away either (Altoona)

    I am an Industrial Engineer by training, used excel often on projects. Now am a security guard at a vets home (long story, dont ask lol)

  15. #15
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by FDibbins View Post
    ......Now am a security guard at a vets home (long story, dont ask lol)
    ... love of Dogs ?

  16. #16
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Yes, I do love dogs, but this is a veterans home

  17. #17
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Hey, I'm a veteran.

    You just might end up guarding me one day!

  18. #18
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Tony Valko View Post
    ......

    You just might end up guarding me one day!
    ... I am saying nothing..

  19. #19
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by FDibbins View Post
    With only 69 posts, leaving would hardly be taking a break?
    . lol. Indeed.

  20. #20
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Doc.AElstein View Post
    P. P.s . I wish i could earn £350 a Day from computing. I am working privately on zero budget on an important personal project. I actually find VBA programming fun sometimes. Never occurred to me that one could get paid so much for doing it !!!
    If I ever manage to get a foot into the finance industry then the very next contract will be in London for £550 a day. However, those gits in banking always want experience and don't seem to appreciate that VBA is still VBA. Mind you, the other day I found out a program manager at the place I'm currently contracting got the push cos she basically did bugger all all day.....and the project now had an extra £850 a day budget available. !!!!. I'm in the wrong racket....

  21. #21
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    And what's with this newbie compulsion to split data all the time? I spend enough time gathering external data into a coherent, queryable dataset. Why on earth would I want to separate it into sheets?

  22. #22
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Oops, double post.
    Last edited by BellyGas; 08-05-2015 at 05:53 PM.

  23. #23
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by FDibbins View Post
    Pretty much because it is forum where members (developers or not) hand out solutions for free

    Nobody is obligated to respond to any thread from any member here, we all do so because we want to. I am sure most members here have come across a thread that has "pushed their button", and the advice to them is always - if you dont like it, dont reply/respond, just move on the next thread where, perhaps, your help will be more appreciared.

    This rant (and I mean that in a good way) raises it's head periodically - you are not the 1st, nor will you be the last -, and it can be good to let off a bit of steam now and then.
    Yep. See.....where I'm coming from is sorta like this: I learned VBA the hard way, I'm self taught and I'm still hoping to learn more every day. I seem to have a flair for UI design though, and so the things I do in Excel generally look the business and....as I'm sure you're aware, users go "coo" over the simplest things if they look nice. This, and a certain amount of luck, landed me my first VBA dev contract a few years ago and I've been lucky enough to keep finding contracts ever since. And yes there is a lot of luck involved cos I've had the kinda contracts that allow me to play with computers making them do flashy things rather than just number crunching or supporting other peoples code, we're talking proper app dev from requirements gathering through to deployment. I get to imagine how things should be....and then make it so. I have THE BEST ****ing job in the world.

    I tell ya, if I had access to the source code I really would change the world. And there's a lot of people who'd be in some serious s**t too.

    But anyway, digressing. As I say, I've worked hard and been very lucky. There's a lot of other people around who also want to learn, to work at it, to gain the ability to imagine how they want it to be...and make it so. And I respect that, more than you can imagine. And so, if someone wants to learn I will happily, gladly, willingly help them. And there are more who have learned but haven't got the experience to be able to land a decent contract / job......but are quite capable of providing services for small 'fix my spreadsheet' jobs and could, possibly, make a few quid out of their talent.......if these damn lazy cheapskates didn't keep getting solutions for free. ;-).

    I'm oversimplifying I know, it's just for comedy effect.


    Lemme tell ya a quick story. That first dev contract I had was for a huge company who outsourced pretty much all their IT to an Indian company. Once my app was complete they were contracted to provide ongoing support of the users (around 2000, spread all over the country). I am willing to admit I was not impressed with them in the slightest and so, to illustrate my concerns to the boss, I created a fake support situation at one of the remote offices. A few hours later a section of my code was posted in this very forum with a request for a 'code fix' by an Indian chap.

    Ahem.

    And they were charging £30,000 a year for this support.

  24. #24
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I take your point, and Im sure this happens to some greater of lesser degree on here, as well as other forums. We are not going to stop it, even if we wanted to.

    Bottom line here is that, no matter what your view, background, preferences etc, this remains a free forum, where members come for free assistance - be that "teach me to fish" or just plain "catch a fish for me". If someone is not comfortable answering a question, move on...that simple - I have done that more than once

    Judging by the kind of questions being asked, I would say that probably by FAR the greatest number of posts here are business-related, it's the nature of the beast. Would I like to get paid for what I (love to) do? Sure. Will I stop helping here and a few other forums, if I dont get paid? Not a chance, thats not why I am here, not why the majority of members are here.

  25. #25
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I've learned a lot on this forum - when I see a thread that I'm interested in but don't have a clue, I subscribe to it. Although many go unanswered, some get answered and I learn. Also, if I've worked up a solution to a thread I always post it whether or not someone else has answered(well, almost always)

    I'm a retired School Teacher and Excel Programmer/Developer but looking for work
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  26. #26
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Interesting, I was starting to ask myself what most of the posters that primarily give solutions here do for a living. I'm a financial modeller (by chance) and visits this site from time to time for a short distraction and to see if there are any interesting topics to look into.

    This post also answer my other curious thought as to why some posters have such high frequency of questions yet the questions seems to be completely unrelated to one another.

    Definitely learnt heaps of things here. Until recently I didn't know what CSE stands for...

  27. #27
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    ... and I'm a sort-of self-employed consultant in areas relating to analytical chemistry and EU regulatory affairs. I've learned a pile on the EF in the last year or so; but it can be a bit time consuming. Having said that, I expect to be here a lot in the next week or so as I'm on a business trip to a country with a serious security problem. My hotel is a bit of a fortress, so there's not much to do in "down time". There isn't even a bar where I can take refuge...
    Glenn



  28. #28
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I'm an Inventory Analyst for a large contract manufacturing company. I work in the purchasing/materials department. My job title isn't really what I do though. I'm really a data miner. I use SQL to dig out data from JDE/Oracle. I use TOAD sometimes, Rapid Response, XL, PL/SQL and a few other things. I use XL/VBA to automated the heck out stuff. I do about 190 standard report throughout a QTR that are all automated. That does not include one offs. I do have an IT background (IT Manager for 5 years,20 years in SysAdmin/Network Admin). I love what I do because I learn something everyday and I work with great people. I'm extremely lucky.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  29. #29
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2013
    Posts
    1,416

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    \_0.0_/

    Perfect example... I totally just learned a whole to way to do something I've literally done 1000's of times...

    http://www.excelforum.com/access-tab...onnection.html

    Seriously ... I'm glad I visited that thread again and spent half an hour researching what the F he was talking about.... MIND = BLOWN

  30. #30
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    ........

    Quote Originally Posted by Doc.AElstein View Post
    ...... I expect many people register with a new made up name and e-mail address every time they want a question answered and so avoid people .... "sussing them out".. ....
    ..................

    Quote Originally Posted by Tony Valko View Post
    I'm "semi-retired".
    Worked at a plant .....
    Quote Originally Posted by GeneralDisarray View Post
    .... I work in oil-field service in the USA - ...
    Quote Originally Posted by FDibbins View Post
    GD and Tony, you guys may be neighbours? Im not that far away either (Altoona).....I am an Industrial Engineer.....)
    Quote Originally Posted by xladept View Post
    ........
    I'm a retired School Teacher and Excel Programmer/Developer but looking for work
    Quote Originally Posted by quekbc View Post
    .......... I'm a financial modeller (by chance) .......
    Quote Originally Posted by Glenn Kennedy View Post
    ... and I'm a sort-of self-employed consultant in areas relating to analytical chemistry .........
    Quote Originally Posted by judgeh59 View Post
    I'm an Inventory Analyst for a large contract manufacturing company. ......
    .. Maybe this Thread should be re titled "Outing" of the "real" people

  31. #31
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Doc.AElstein View Post
    Maybe this Thread should be re titled "Outing" of the "real" people
    And the problem being....?

  32. #32
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by quekbc View Post
    And the problem being....?
    . ? .... no problem. I meant it positive.. ....my criticism was aimed at the Anonymous "one Threaders”:
    Post #6
    http://www.excelforum.com/the-water-...ml#post4154066

    . " keep it real man "

  33. #33
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Haha, I understand now. Brain needs time to warm-up.

  34. #34
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Doc.AElstein View Post
    ........

    .. Maybe this Thread should be re titled "Outing" of the "real" people
    Yes, it kida has got way off track from the OP's topic

  35. #35
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Another slightly off-topic, anyone noticed how the "type" of questions seems to come in waves? I remember, last week or so, there were quite a number of posts on calculating hours for different type of shift work. I can't remember other specific examples, but I do notice this pattern from time to time.

  36. #36
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by quekbc View Post
    .... anyone noticed how the "type" of questions seems to come in waves?.....
    . Homework from a big class of students? - One student has sucess at the Forum so passes it on to his class mates?

    . At another Board I am on it was noticed that at certain Symester Starts that a lot of the "One Threader", Funny Name poster's were about
    Last edited by Doc.AElstein; 08-06-2015 at 08:46 PM.

  37. #37
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I thought that questions come in subject waves too, but I can't make my mind up whether this is objective or subjective. I don't know if I'm seeing patterns that aren't really there, if I read a couple of questions that are similar I tend to spot more similar ones - but I'm not entirely convinced that means that there are waves or my brain is making connections, much like when doing a word search. I've never cared enough to run the analysis though...

  38. #38
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by quekbc View Post
    Another slightly off-topic, anyone noticed how the "type" of questions seems to come in waves? I remember, last week or so, there were quite a number of posts on calculating hours for different type of shift work. I can't remember other specific examples, but I do notice this pattern from time to time.
    Not waves perhaps but several times I have solved non-trivial problems, maybe even hard and "unique" ones just to see a remarkably similar problem being posted from another part of the world a short time after, sometimes just 5 minutes. I don't think there is a connection, I think it's just that randomness isn't as even as I picture it in my head.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  39. #39
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    .... or my brain is making connections, much like........
    when a Film comes on the Telly, I often think.. B**ger me!, I was thinking about that film just the other day
    Quote Originally Posted by FDibbins View Post
    Yes, it kida has got way off track from the OP's topic
    ... coming “back” a bit....
    Quote Originally Posted by FDibbins View Post
    . .. it is forum where members (developers or not) hand out solutions for free...Bottom line here is that, no matter what your view, background, preferences etc, this remains a free forum, where members come for free assistance - be that "teach me to fish" or just plain "catch a fish for me".....
    ..Some people make no secret about it, using forums like these to do all their work, always asking, never giving, - just one of many:
    http://www.mrexcel.com/forum/search....archid=3014526
    http://tinyurl.com/nfqahg6
    . Even seen them “Bump” after an hour with “Hey I need this for my Work!!!”....at least they are honest and “stay real” as I say.. ( Puzzles me slightly that they often get quick responses )
    .....
    Bottom line for me is I just I get a ( little ) bit annoyed by the Anonymous one Threaders that “vanish “ after a good answer ( at least in that current Anonymous name). But that is partly just because due to my ( lack ) of ability, I only am left to answer the tedious but less technically challenging Threads. But I always take the liberty of trying something a bit new when I answer, even if it does not give the best solution, so I learn a bit. ( I suppose I could give a really smelly Fish, I stumbled on a way to “crash” an EF Thread the other day, but it is against my principals to do that - )
    .FWIW. a last comment, it would be nice if at least some “legality” could be required for members when registering. That is why the diversion to people “outing” in this Thread I found cool
    Alan
    P.s.
    Quote Originally Posted by Jacc View Post
    ...... see a remarkably similar problem being posted from another part of the world a short time after, sometimes just 5 minutes. I don't think there is a connection,......
    ... maybe another way to "bump" anonymously.....I have caught out and reported OP's several times that ask a mate somewhere else in the world to either answer their Thread to "bump" it, or ask a similar question to "bump" the Theme..
    Last edited by Doc.AElstein; 08-07-2015 at 01:10 PM.

  40. #40
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Nah, I don't think so in my cases. There has been cases that happened right after the first problem was solved. Also the problems have been way different, only the solution has been very similar in concept. I think it's just one of those weird random things.

  41. #41
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Doc.AElstein View Post
    That seems to be a dead link. I get this message:

    vBulletin Message


    Sorry - no matches. Please try some different terms.

  42. #42
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Hi,
    Quote Originally Posted by Tony Valko View Post
    That seems to be a dead link. I get this message:
    Ahh, I think you need to log in, if you are registered there, ( It is MrExcel Forum ), - It was just an OP example that sprung to mind and I did not pay attention as to where it was, sorry about that. Basically it is just an OP that asks endless questions, often bumping after a short amount of time, and often freely admits he knows nothing and wants someone to do his work for him. He gets lots of help. I have at least a little bit of repect that he is honest and stays "real", - the point I had brought up a bit in this Thread

    Alan
    Last edited by Doc.AElstein; 08-07-2015 at 10:08 AM.

  43. #43
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    No, it's because the searches are cached and they expire, to get the search url right click on the link to show started threads and copy that. You can't got to it and then copy the url.

  44. #44
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    .... to get the search url right click on the link to show started threads and copy that. You can't got to it and then copy the url.
    . Ok , sorry to make a mess. The OP is Dazzawm .... This is link as you suggested:

    Find latest posts

    .. seems to work for me when copied to WORD ...
    But not when I copy it here - . It only copies in as simple text...

    ... I think what you suggest only works with the Enhanced Interface - Full WYSIWYG Editing which EF Forum does not appear to have in
    >> setting >>> general settings >>> Message Editor Interface:

    ... I just did it at Mr excel and with ( and only with Full WYSIWYG Editing ) it works..
    http://www.mrexcel.com/forum/test-he...l?#post4239384
    Last edited by Doc.AElstein; 08-07-2015 at 10:31 AM.

  45. #45
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I'm not really sure what you're trying to do, simply:

    Then paste in the textbox?

  46. #46
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    I'm not really sure what you're trying to do, simply:
    ......
    Then paste in the textbox?
    .. Thanks kyle, I did exactly that.... I updated / editted my Post #44 as you posted Post # 45
    EDIT
    ... try again .. My browser does not give exactly the same options as yours... I have an option for the address:
    http://www.mrexcel.com/forum/search....t&showposts=1&
    http://tinyurl.com/nfqahg6
    EDIT EDIT - well that last one seems to work, at least now.... whether it expires later?
    Last edited by Doc.AElstein; 08-07-2015 at 01:08 PM.

  47. #47
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    It definitely didn't work

  48. #48
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    It definitely didn't work
    .. Still works for me. The usual different Browser Stuff. Anyways i have distracted the Thread again too much, sorry about that.
    The OP name is Dazzawm and, maybe one of these links will work for some people.
    http://www.mrexcel.com/forum/search....t&showposts=1&
    http://www.mrexcel.com/forum/search....BForum_Thread&
    http://www.mrexcel.com/forum/search....t&showposts=1&
    http://www.mrexcel.com/forum/test-he...l?#post4239384
    http://www.mrexcel.com/forum/test-he...l?#post4239384
    http://www.mrexcel.com/forum/search....t&showposts=1&
    http://tinyurl.com/nfqahg6
    Last edited by Doc.AElstein; 08-07-2015 at 01:08 PM.

  49. #49
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    When I click any of your links the 5 dots in the middle show up in my browser address bar exactly like they do in your post. I think the dots are placeholders for information that simply isn't there.

  50. #50
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    The first & second ones works for me

  51. #51
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    The first & second ones works for me
    ... we could play around for ever I guess.... It seems to be very dependant on when , how , you copy paste ( selecting the different options to paste and copy , right mouse click or Ctrl C , Ctrl V etc.. etc... Another experienced Pro ( RickXL ) once said to me that down the road of trying to figure out which version of the clipboard is / if used leads to madness...
    . .. and editing posts confuses further when sometimes that changes things etc. etc.. etc...
    . But I have noticed that the lack of the 3rd editor option at EF reduces the chances of "sucess".
    Last edited by Doc.AElstein; 08-07-2015 at 11:34 AM.

  52. #52
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Maybe this? http://tinyurl.com/

  53. #53
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Jacc View Post
    .... the following is made via Tiny ( A link that kyle said worked ... and Jacc said was incomplete.....)
    http://tinyurl.com/nfqahg6
    ( In the Editor it shows to me as a link to Tiny site
    EDIT Works for me. But always, like the Image Issue, using external sites often helps... in the short term... but the consequences in the future.... junk mail, or other virusis sneaking in when you access external sites?? But thanks for the Tip, got the Tiny link stored, might help sometimes getting over URL problems in the future.
    Last edited by Doc.AElstein; 08-07-2015 at 11:50 AM.

  54. #54
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Yup that works.

  55. #55
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    what were we discussing about again?

  56. #56
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by quekbc View Post
    what were we discussing about again?
    Ha Ha ........ About being "real"

    . ( If this was not the Water colors, JBeaucaire would have wiped out most of these Posts!!! )

  57. #57
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    And maybe we need to get back on track with taht - unless that discussion is ended?

  58. #58
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by FDibbins View Post
    And maybe we need to get back on track with taht .....
    . Sorry about my diversions , but the “outing” of the “real” people was nice.
    Quote Originally Posted by FDibbins View Post
    ..... - unless that discussion is ended?
    .. maybe a quick attempt at redemption, back to the original OP ... and general Theme...
    .....
    Quote Originally Posted by Doc.AElstein View Post
    Hi,
    . I actually fully agree with your sentiments, ........
    ....
    .......
    . P.s – the last thread you criticised from danfullwood, is exactly the sort of Thread I have usually been able to / left to answer in the past. Except mostly they were considerably bigger and more complicated!!!, and I had a big struggle initially to get the OP to produce reduced sample data as danfullwood has already done. So I may be tempted to have a go at that one, as a “quicky” ( relatively speaking for the Threads I have answered of that nature!!)............ ...!
    .. well I did...a few days back....
    http://www.excelforum.com/excel-prog...ml#post4154341
    .. ... and...
    . = “”


    (... Sort of supports the OP, his criticisms, my comments about the anonymous “One Threaders” etc. , but I have seen in the meantime the other extreme of great feedback also...
    http://www.excelforum.com/excel-prog...ml#post4156085
    ... )
    ... That’s life, “Up and Down”
    Alan Elston
    Old Physisist, no idea about Computing, learning VBA to help with personal Project. "Stuck out in the Bavarian Hills" etc. etc.

    P.s.
    .. A last thought on encouraging “Being real”.. I know that the Forum software checks for unique usernames at an E-mail address. But that means nothing: I know nothing about computers but can create a valid email in about a minute. And there is no limit to the number I can make, (all free). I am sure most people can automate that to do it at a click, ( or at a F5..).. But what is this “IP” thing ? Is that “unique”? If more than a few people at an “IP” registered , could the software then require / ask for some legitimacy?? Or can one man make a IP easily?
    Last edited by Doc.AElstein; 08-09-2015 at 07:04 AM.

  59. #59
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Alan, to answer your question...
    But what is this “IP” thing ? Is that “unique”? ....
    An Internet Protocol address (IP address) is a numerical label assigned to each device (e.g., computer, printer) participating in a computer network that uses the Internet Protocol for communication. An IP address serves two principal functions: host or network interface identification and location addressing.

    IP address - Wikipedia, the free encyclopedia

    https://en.wikipedia.org/wiki/IP_address

    Wikipedia

  60. #60
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Hi FDibbins,
    .
    Quote Originally Posted by FDibbins View Post
    Alan, to answer your question...
    .. Thanks for the reply and info.
    . I had roughly got that idea from googling but was not too clear exactly , that is to say how "Unique" it is, - your quote along with the reference you gave could be interoperated to mean initially that each device / computer at "an address" might have a unique number- But I just tried a few computers simultaneously running by me here at home and then on each "googled" my IP address ( there are loads of free sites that give you your address ). The result was that all my Computers here have the same IP address ( I have some sort of splitter on the telephone cable coming through the wall from which I get my internet connection ). So clearly an IP address seems to refer to "a place" or a telephone line rather than a computer. – Similarly I have a couple of internet OSB “sticks” which i am able to get internet through. They both appear to have a different “unique” IP address.
    . Getting back then to my original point: I suppose it could be legitimate to have lots of "valid" , that is to say "real" people using one IP address, for example at a large company with one or more main “Lines” connected to the internet.
    . But I would think it would still be reasonable for a Forum such as Excelforum, say , after the 3 or 4th registration at an IP address to ask for some legitimacy to the person registering. That is very reasonable considering the excellent free service the company would be receiving from help at the forum.
    . However this was a minor point that I thought appropriate in this Thread to bring up.
    . Just to clarify my reason for this: I expect many people abuse the forum by re registering with a made up email and username every time they want help. This disguises / hides any bad doings / poor feedback etc, they may have given at their last visit under a different email address and user name. Also I have clearly seen that statements similar to the following often result in an OP getting a better response ...." Hi, this is such a great forum , I have learnt so much already and can usually always find what i want here, but this problem I just could not find, so i registered. Please can you help...."

    . Alan

  61. #61
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Just to feed into your question/comment above about multiple devices having the same IP, maybe this will also help...
    A subnetwork, or subnet, is a logical, visible subdivision of an IP network. The practice of dividing a network into two or more networks is called subnetting. Computers that belong to a subnet are addressed with a common, identical, most-significant bit-group in their IP address.

    Subnetwork - Wikipedia, the free encyclopedia
    https://en.wikipedia.org/wiki/Subnetwork

    Wikipedia

  62. #62
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by FDibbins View Post
    Just to feed into your question/comment above about multiple devices having the same IP, maybe this will also help...
    .. Thanks again, - mine "divides up" into about 8 I think, I guess a big company could somehow divide up to lots, ...
    Alan

  63. #63
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    any time, and thanks for the feedback

  64. #64
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I'm no expert in networking, but here is what I understand.

    The ISP (Internet Service Provider) assigns you an IP address. This assignment of IP addresses are generally done in 2 ways. First type is a static IP. That is, every time you connect to the internet (imagine the dial-up sound of a 56k modem), you get the same IP address. The other type is called a dynamic IP address. That is, every time you connect to the internet (dial-up model sound again), you get a different IP - generated from a set of IP address that the ISP holds.

    In the case of static IP, yes, they are "tied" to a "place" - sometimes to an "account" (i.e. if and when you move houses but maintain the same account, they keep the IP for you).

    In terms of legitamising accounts, it's a difficult thing to do. A person may have signed up to an ISP that assigns dynamic IPs (i.e. multiple IPs at different points in time to the same person). Someone can choose to have multiple accounts with multiple ISPs - so a "place" can have multiple IP addresses. Or, they can connect to a separate server using a VPN, thus showing up as the server's IP rather than their own (e.g. you connect to your office computer, and use the office's internet).

    Not that any of this helps the process of legitamising accounts - but its a glimpse into how difficult it can be. Common methods that I know of in trying to "uniquely" identify computers are through things like cookies, which most browsers nowadays can clear / block the use of cookies).

  65. #65
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by quekbc View Post
    I'm no expert in networking, but here is what I understand. .....
    .
    . Thanks for that.
    . Clearly legitimising accounts is not as easy as I was thinking. And "turning a blind eye" is one way to help "get the membership quota up" anyway - so it is not something the powers that be would want to push...
    ... I do not mean that as undue criticism. I have greatly benefited from ( free ) help here, so I have no right to criticise how they may help to make the Forum attractive to companies advertising here etc...in order to finance the Board...
    . I just find it a shame when regulars are abused for freely sharing the benefit of their knowledge and experience by un serious users, or people just to lazy to learn do their homework or re contribute back to the board.. – the original jist of this Thread..
    . Alan

  66. #66
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Understandable, Alan. I myself am more irked by an earlier post where someone fake requested IT support from a third party consultant only to find the question posted right back here by someone else - presumably the consultant.

    Whilst I am happy answering some of the queries, I don't know how to feel knowing that some of the solutions are being used by someone else for a quick buck.

  67. #67
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I guess that goes with the territory, not all members have the same ethical standards. For myself, I am here to help, in just about any way I can - after a while here, you get to know many of the members, and can sometimes tell when a member is just "using" us.

    It all boils down to - if you dont feel comfortable/willing to help a particular thread - or even member - leave it and move on

  68. #68
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by FDibbins View Post
    It all boils down to - if you dont feel comfortable/willing to help a particular thread - or even member - leave it and move on
    Most definitely, but it still irks me nonetheless. It's a cold world out there (and in here).

  69. #69
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by FDibbins View Post
    ......
    It all boils down to - if you dont feel comfortable/willing to help a particular thread - or even member - leave it and move on
    .. I agree with that also. Just surprised sometimes that some members who clearly ask daily many unrelated questions without feeding back much get good quick answers, even when bumping quickly... and then some who contribute what they can often get no response... sometimes..
    Alan

  70. #70
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    The problem with IP addresses is that they change all the time, the IP address you have now can change at any point (unless you've paid extra for a static IP address) so IP filtering doesn't really work.

    What would legitimacy look like for someone registering, all you can possibly verify about someone is their email address - and this verification is already done

  71. #71
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Oops, didn't see this third page when I posted that

  72. #72
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    .......
    What would legitimacy look like for someone registering, all you can possibly verify about someone is their email address - and this verification is already done
    .. it was not a big point,. I think I get the point now verifying legitimacy is difficult, if not impossible
    Alan
    P.s. - I remember hearing that when you register with Microsoft for the "free" VB 2010, then after 30 days you can only continue to use it by giving a lot of personal details, home address etc. But I confess that sort of "spying" on me I do not like.
    . It is a very difficult Theme. .. I guess if you insisted on logging in to use the site at all and you and your "visits" were logged, then it would put people off, effect "clicks" on the site, and reduce popularity with people looking for sites in which to advertise.
    . I think I have laboured this point a bit much.
    . Bottom line it just can't be done. And as often commented, it is just down to the individual to decide who he / she helps... No way of getting over that. And what goes on behind the scene that makes some persistent takers who never give, but always receive lots of help... no idea there, maybe some people know each other outside the forum and “pay in kind” or whatever,.. no idea.
    .
    . As far as I am concerned I am just going to give as much good feedback as I can to the people who are kind enough to help me, try to make threads i start useful for others, and ( for now, until I get better, ) still answer the difficult but not technically challenging Threads, that inevitably will have a higher proportion of people just trying to get their work done freely... But it is not always the case as.. I also mentioned a lot before.
    Last edited by Doc.AElstein; 08-10-2015 at 06:34 AM.

  73. #73
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    Oops, didn't see this third page when I posted that
    Happens to me a lot.
    .I would prefer to get notified of all post in a thread I am subscribed to. But Other's wouldn't. I do not think there is a setting to mofify that?. I think the usual statment is
    ...."..There may also be other replies, but you will not receive any more notifications until you visit the forum again.."..

  74. #74
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Hi Doc,

    Thanks for the information on Windows 10 - anything else about it that we should know?

  75. #75
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by xladept View Post
    Hi Doc,

    Thanks for the information on Windows 10 - ...:
    yous welcome.., I will keep my ears open if case any thing else is said about it on the news..
    Alan


    https://www.verbraucherzentrale-rlp....etzten-klick-1
    http://tinyurl.com/pzqkogg

    P.s.
    ( Did you accidently post in the wrong thread ? .. did you mean to post here
    http://www.excelforum.com/microsoft-...0-upgrade.html
    )
    P.P.s. one extra small strange thing...
    . A few years back I got a LG x120 Notebook for my Wife.. It only had Windows 7 STARTER version ( A scaled down version of Windows 7 ) At the shop they said the Note Book was only really good with XP and the Full Windows 7 probably would not run on it.....and I would have to pay for it... Today on that Notebook the Window keeps comin up asking me to instal ( for free ) Windows 10... Strange
    Last edited by Doc.AElstein; 08-10-2015 at 03:24 PM. Reason: added link

  76. #76
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Hi Doc,

    I didn't know about that other thread - thanks for the link

    My life has been a catalogue of unawareness

  77. #77
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."


  78. #78
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Hi,
    . …and you can expect spending ten times as long as necessary to get the simplest point across because of language differences….
    . … just try amusing yourself if you take on such Threads…..
    http://www.excelforum.com/non-englis...ml#post4176824
    http://www.excelforum.com/excel-prog...ml#post4165120
    Last edited by Doc.AElstein; 09-01-2015 at 08:16 AM.

  79. #79
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Doc.AElstein View Post
    SpoonFeedADonkeyWanks.xlsm
    LOL LOL LOL. *applause*

  80. #80
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    These "outings of the real people" are my favorite threads on the forum.

    It goes to show that deep down inside, we're not just a bunch of cantankerous old men. Sometimes, we can smile too.

    Also, the DonkeyWanks thread is comedy gold.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  81. #81
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    How come DonkeyWanks hasn't had the forum censor police all over it yet?

  82. #82
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I think my greatest offenses are when someone posts an image of something highly complex and involved with no workbook.

    And then in moments of controlled fury, I replicate the entire workbook from scratch with the desired result, and post a picture of it.

    Kind of like this:
    Capture2.jpg

  83. #83
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by daffodil11 View Post
    ... moments of controlled fury, I replicate the entire workbook from scratch with the desired result, and post a picture of it.....
    . Hey I like that, I guess my controlled fury is trying to amuse myself..

  84. #84
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    @daffodil, that's nothing - I've seen users draw and take a photo of their workbook and upload that...

  85. #85
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    How come DonkeyWanks hasn't had the forum censor police all over it yet?
    Consider me here, now. I find this thread hilarious, and even more so I find it sad.

    Humor at the expense of an OP is a breach of rule 6b. If you can't help in a thread without remaining respectful and courteous at all times, then walk away from the thread, courteously.

    I know the OP seems ignorant of the fact that he is being made fun of right to his face. Hilarious. And offensive beyond doubt. Much of humor is funny because it is offensive, this is prime example.

    So, let me be clear. Do not make fun of OPs in the forum in any manner that they could ever see. It is discourteous to lay an insult at someone's feet and "hope" they don't see it.

    So stop it.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  86. #86
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by daffodil11 View Post
    I think my greatest offenses are when someone posts an image of something highly complex and involved with no workbook.

    And then in moments of controlled fury, I replicate the entire workbook from scratch with the desired result, and post a picture of it.
    I admit to having done this once or twice in the past. No more. Its funny, but if I'm going to spend time AND help others who may find the thread in the future, I need to behave in my answers. If I take the time to create a workbook now, I post it. Usually I thank them for the detailed pic and ask for the workbook, which is the courteous teaching approach.

  87. #87
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Doc.AElstein View Post
    Hi,
    . …and you can expect spending ten times as long as necessary to get the simplest point across because of language differences….
    . … just try amusing yourself if you take on such Threads…..
    http://www.excelforum.com/non-englis...ml#post4176824
    http://www.excelforum.com/excel-prog...ml#post4165120
    The correct thing to do in a thread where the OP is struggling with the English is to answer in perfect English. Correct examples of the language they are struggling to learn is helpful, incorrect examples simply reinforce their current errors. This is a teaching forum and in all things we are teaching good things. So do that.

  88. #88
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Amen - Jerry!

  89. #89
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    What I can never quite get my head round, is that it is quite common to see poor non-english speakers write in text speak. I can never quite make up my mind how they have learnt this; is it something they've learnt after English that makes their posts unnecessarily difficult to understand or is it how the'ye learnt English? It makes their posts often incomprehensible at best.

  90. #90
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by JBeaucaire View Post
    This is a teaching forum and in all things we are teaching good things. So do that.
    A-bleedin-men.

    I think the first lesson that needs to be taught is how to use Google.

  91. #91
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    What I can never quite get my head round, is that ... poor non-english speakers write in text speak. ......

    Hi,
    . I sometimes try to reply in this strange “Text speak” back. I find sometimes that is the only way to get the message across and so get there in the end. That is part of my “Third language” which often gets a solution where all and everyone else fails , ( or needs an unreasonable amount of time, - so preventing them helping a lot more people as many very helpful regulars do here. I am always amazed how many threads many regulars answer.- about 100 to my 1 . That is what really puts me in my place )

    . Maybe when the Google translator gets a bit better all will be good.
    . I speak and can almost write fluently in my main two languages, English and German. I find the Google translator very useful. Helps me with my terrible spelling and gives me half the sentence to then further work on. I do not think it is yet at the level that it can be used on its own, although I frequent see in Threads here that the OP attempts that.

    . I need to perfect my “Third language” to get it more universally acceptable. I hope to do so. I like to help in any way I can. If I can amuse myself at the same time I try, but I should not do that at the OP’s expense, I guess.. Maybe it was OK to call George a Wanker, in the DonkeyWanks Thread. I know he is, and he is proud of it. There are proved health advantages to wanking. I should not, however, have insulted the Donkey, inferring he should be wanked. I apologize for that. I am an animal lover myself, ( as far as the Wife permits )

    . Alan
    Last edited by Doc.AElstein; 09-03-2015 at 06:41 PM. Reason: Just a typo - Honest

  92. #92
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    What I can never quite get my head round, is that it is quite common to see poor non-english speakers write in text speak. I can never quite make up my mind how they have learnt this; is it something they've learnt after English that makes their posts unnecessarily difficult to understand or is it how the'ye learnt English? It makes their posts often incomprehensible at best.
    I agree. Again, as courteously as I can, I request OPs to not use text speak when I encounter it.

    As a moderator I'm able to actually edit their posts to remove it and replace it with regular words, then point it out and ask they do the same. Maybe just click the REPORT button when you see it so you don't have to feel responsible for dealing with those peripheral issues.

  93. #93
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by BellyGas View Post
    A-bleedin-men.

    I think the first lesson that needs to be taught is how to use Google.
    I always assumed this is what most problem solvers here do. Asking the internet the right question is the hardest part though.

    When I run into VB 6.0 and Access roadblocks, I feel like an idiot all over again, Google'ing 'Why are there jet engines in my Access database"

  94. #94
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,362

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    If I'm honest, I often Google the problem, and sometimes just post the relevant links, or a selection. To be fair, as you say, the most difficult part is knowing what to Google.

    However, I do get a little frustrated sometimes when it appears no effort has been made ... and you see the same or similar questions near each other in the forum thread list. Classic: how do I hide rows based on the contents of cells in column A, or whatever?
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  95. #95
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    www.lmgtfy.com is my best friend nowadays.

  96. #96
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Kyle123 View Post
    What I can never quite get my head round, is that it is quite common to see poor non-english speakers write in text speak.
    ...... Our Friend "Brain ache" is back... might 'ave another go....
    http://www.excelforum.com/excel-prog...ml#post4165110
    http://www.excelforum.com/excel-prog...ml#post4182395
    Last edited by Doc.AElstein; 09-05-2015 at 08:54 PM.

  97. #97
    Registered User
    Join Date
    01-07-2015
    Location
    Nottingham
    MS-Off Ver
    2010
    Posts
    74

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I hope this post helps with frustrations.

    When I first started here I knew diddly squat and never wanted the 'solution' but the right road to take to get there myself, I wanted to learn and understand.
    I found myself in a position at work where I wanted to deliver things I knew I had little to no knowledge about, but I am a self driven a highly motivated person who learns best with trial and error, but when I found myself at a solid wall with no direction to go this forum helped me.

    The help and support and direction I have been offered on this forum has been truly amazing and I have appreciated every second that people have taken to assist me and I have learnt so much it is awesome.

    Dont get me wrong if someone had given me the 'exact' reams of code I required my delivery of so much would have been so much faster, but I would still have been an excel dimwit as I was at the beginning, I am still a novice, but what I know I now know well and with confidence and can teach and share with others and know what I am offering is quality.

    I can thank only the amazing boys and girls here to offer their time and knowledge, some of us REALLY appreciate it.So thank you seems inadequate, but it is very sincere.

    I also completely understand the frustration albeit from a different place. I have spent years training my horses for competion, hours of blood (literally) broken bones (literally) sweat and tears, in all weathers and at stupidly early and late hours of the day and when some says, 'Oh you have horses, I rode once can I have a go' I want to punch them, because that is sooooo not how it works, my horses would kill them because of their lack of knowledge. I would be and have been happy to help and teach and suppport them achieve equine goals, but never hand anything on a plate.

    This may be two different experiences but I know the frustration you feel so wanted to let you know that some of us, really do learn and want to and appreciate every second you offer us.

  98. #98
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Thanks for your thoughts, we are so glad we've been able to help push you along your Excel learning curve.

    There is a significant difference between someone coming to your place of hard-earned skill and show and acting all "in the know", thus disrespecting what you do and have done.... and those coming here to a place of asking where free assistance is happily offered and find themselves talked down to or abused by the very people supposedly "happily helping".

    Here, I am frequently having to remind our helpers that the free help freely given IS the reward, and the OPs ultimately don't really owe us anything. Help where you can, or move on to other threads, but avoid wherever possible becoming overly harsh or ill-mannered with an OP, even if they may deserve it, a little.

  99. #99
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by JBeaucaire View Post
    .......
    Here, I am frequently having to remind our helpers that the free help freely given IS the reward, and the OPs ultimately don't really owe us anything. Help where you can, or move on to other threads, but avoid wherever possible becoming overly harsh or ill-mannered with an OP, even if they may deserve it, a little.
    Understood. I think I have more that “redeemed myself” in the last few days with any OP’s I may have offended, bringing them to a final solution where sometimes, everyone else failed…. Even if they may not have fully deserved it…
    Alan

  100. #100
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    And thus, that IS the satisfaction we all seek. Good job! (thumbs up)

  101. #101
    Registered User
    Join Date
    01-07-2015
    Location
    Nottingham
    MS-Off Ver
    2010
    Posts
    74

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I do agree though that an idiot is an idiot and should not be tarred with a non idiot brush for the sake of niceness, besides it leaves said idiots becoming disillusioned into believing they are not in fact idiots, when clearly they are

  102. #102
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    But it will never be clear the THEM, so let's help them keep their secret. hehe.

  103. #103
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    What they don't know can't hurt them

  104. #104
    Registered User
    Join Date
    06-13-2013
    Location
    Lincoln, NE
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Some of us are trying to learn from you. Thanks for teaching!

  105. #105
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by thbuster View Post
    Some of us are trying to learn from you. Thanks for teaching!
    That's the important comment in this thread so far.

  106. #106
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Missus Mommabear View Post
    I do agree though that an idiot is an idiot and should not be tarred with a non idiot brush for the sake of niceness, besides it leaves said idiots becoming disillusioned into believing they are not in fact idiots, when clearly they are
    clap clap clap clap clap clap

  107. #107
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    .. maybe a compromise acceptable to us all is wot i have recently done at relavent points in a Thread Reply....
    "....I needed a macro here that is so simple it could write it with the macro recorder.."..
    .. so here it is... and then i modified it a bit ... " etc.
    _ Leaves it open to interpretation , helps me remember with a bit of amusement this Thread ...... and hey, I still learn sometimes ( or if I an Honest, Mostly ) from what the macro recorder spews out..
    Last edited by Doc.AElstein; 09-21-2015 at 12:50 PM.

  108. #108
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,362

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Nothing wrong with the macro recorder, or using it, at all. I regularly record a specific action to get the core code and then modify it to make it generic and/or specific to the requirement. There's way too much stuff that I don't know off by heart, or even well enough, to be able to just write it out.
    Last edited by TMS; 09-21-2015 at 02:47 PM.

  109. #109
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Yep, I use it almost daily.

  110. #110
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    It's especially helpful to me when I'm working out a solution involving objects I know very little about.

    Like Printing, Headers, Dialog boxes. I'd be lost without the Object Browser or Macro Recorder.

  111. #111
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    The macro recorder is indispensible

  112. #112
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    It's on my QAT

  113. #113
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."


  114. #114
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    He probably thinks his infraction is a compliment and is totally puzzled why he got a week ban from MrExcel...........

    What does your PUNT mean ?
    _....




    EDIT: ( I think I can put this bit back in from what was censored !
    ..... - it could just be innocent language miss – understanding to some extent. It shows a lot of the signs for that. .. I have answered a lot worse. He seems very polite.

    I think we could definitely do with the Forum Rules written in Hindi ....
    Last edited by Doc.AElstein; 02-17-2017 at 01:13 PM.

  115. #115
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    PUNT means "kick". Either "kick this person" or "kick the ball downfield to the other team, I give up."

  116. #116
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,160

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Doc.AElstein View Post
    He probably thinks his infraction is a compliment ...
    I can assure you that he knows it isn't.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  117. #117
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by JBeaucaire View Post
    PUNT means "kick". Either "kick this person" or "kick the ball downfield to the other team, I give up."
    It is also a small, flat-bottomed boat, often propelled by a pole

  118. #118
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,160

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by FDibbins View Post
    It is also a small, flat-bottomed boat, often propelled by a pole
    And as a verb, it can also mean to have a bet on something, to stick your neck out a bit.

  119. #119
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Someone give him a book : "Hindi to English for Forum OPs"

    Last edited by Doc.AElstein; 02-18-2017 at 10:49 AM.

  120. #120
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    [PUNT] is a habit I picked up from another forum mainly populated by Yanks. It's my understand a PUNT is something they do in that silly handball game that they call football, whereby the ball is PUNTED up the field. It's useage on a forum is to indicate a thread being punted to the top.

  121. #121
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Do it in the Rules in the Hindu Way, that might help. PUNT? No thanks !

    My answer was removed/ censored, - with hind sight quite correctly. Apologise for that.

    I had, mistakenly, initially thought you might have suggested that he was screwing about with someone in a bad way, as suggested by a transitive verb definition given a little way down at this site:
    http://onlineslangdictionary.com/mea...nition-of/punt
    I innocently hit on that definition first on a Google search. That tied up with that initial thought, I felt.

    I did not think he was doing that.

    Or at least I thought there was a chance that it may be down to difficulty speaking in English. I have since put a Suggestion for Improvement in that we get the Forum Rules translated into Hindu.
    http://www.excelforum.com/exceltip-c...ml#post4585819
    Considering that the management are from the India area, and we clearly have many Indian OPs, I would have thought that was both a useful and fairly easy thing to do.
    Last edited by Doc.AElstein; 02-20-2017 at 09:40 AM.

  122. #122
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by BellyGas View Post
    ... lazy xxxx who want their work done for them with no brain engagement required. ....you want things done for you with no effort .....
    Along those lines... Just another for the record... ( and this is the censored version !!! ) : -
    https://www.excelforum.com/excel-for...ml#post4603185
    But I think the way we handle these things sometimes is very commendable. It does take patience of a saint, and more time.
    I guess many first time OPs just want a quick answer, and probably sometimes just want their work done for them.
    But it is in everyone’s interest, in my opinion, to try and “educate”... certainly the helpers are trying very hard in that Thread.. A problem with a written media like Forums is that in a few cases , possibly like the OP in that Thread, it is difficult to give a somewhat harder lesson / education .. which might be a bit more efficient , if you know what I mean , ... so you really have to take the arrogance / insults, and try to “convert” them ... or just move on ..

  123. #123
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    And may I just add: Quote from the thread linked above "Dont respond to my post if your not offering to help. You clearly dont know how to do this either since your asking me what worked and what didnt. What a joke. [Offensive comment removed by moderator] and stay away from my post." / QUOTE

    Jesus H. Christ

    Fdibbins, you sir really do have the patience of a saint.

  124. #124
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Both Jerry and I thank you all for your support and kind words, I would like to pass those same compliments on to all the mods (as well as gurus and experts) here who all do an outstanding job, often under very trying conditions.

    You just have to keep in mind that we are all here to help and to learn, and always remember that those we help, may not even be at a level where they even know what questions to ask - if you dont even know that a certain tool even exists, how would you know to ask how to use it?

    We have rules on this forum - as do all similar forums, and we expect all members to abide by them. They may not be the best around, some may need updating, changing, deleted, added, and not all members will (ever) agree to all of them, but gentle reminders of those rules, often goes a long way.

    I know all members are expected to read those rules on joining, but honestly, how often does anyone really read things like that. That being said, if no-one points out the expectation to follow a certain rule/way of doing things, then you simply wont know

  125. #125
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Another example..
    You go the extra mile_.....
    https://www.excelforum.com/excel-for...ml#post4614578
    _.. get there in the end ( and the OP still does not respond to mark the Thread as Solved ... Lol.... ) .. Oh well , move on The extra tolerance, which sadly we pay for sometimes , is a nice characteristic of ExcelForum

    Once in 100 it pays off ... http://imgur.com/BluqeTn http://imgur.com/1MbKutd :-)
    Last edited by Doc.AElstein; 03-27-2017 at 01:10 AM.

  126. #126
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    It doesn't count if you post it yourself Doc. ;-)

    I know, I know, I'm just taking the mickey.

  127. #127
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    @BellyGas - This guy wants to hire you:

    https://www.excelforum.com/excel-gen...ml#post4618989

  128. #128
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Raphaelp View Post
    ...This guy wants to hire you:...
    I think that Thread has been tanked ( deleted ). I expected it probably would be. Probably the OP has been referred to Commercial Services?

  129. #129
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,160

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    No, the OP has been banned as a spammer - he had posted the same on several other forums.

  130. #130
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by AliGW View Post
    ..OP has been banned as a spammer - ...
    Thanks for the info. I just assumed our Commercial Services would have been keen to take his money . So if he was not serious then I geuss anyone who had read that and was considering contacting him should be careful... ( of course they shoulld not have done that anyway as the Rules are against others coming in an offerenng to pay for services from Members.., I think. As I undrstand it the Commercial Services is where you go if you are considering paying for work done by Members here. I think anyone can offer to pay to have stuff done there.)
    Last edited by Doc.AElstein; 04-01-2017 at 05:08 AM.

  131. #131
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,160

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    I didn't do the banning, but he would have had to go to commercial services with a specific query, so this was not a straightforward "take your query to commercial services" situation. Anyway, he's gone. Not going to discuss it any further!

  132. #132
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,960

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by AliGW View Post
    No, the OP has been banned as a spammer - he had posted the same on several other forums.
    Maybe I've missed somethimg since I've not read all 100+ threads but that doesn't appear to be the case given that Bellygas posted only 3 days ago? And the name certainly doesn't feature in the list of banned users.

    However if we can return to the original subject:


    "but I'm too lazy to use it."

    Seeing more and more of these lately. This thread is my vent at lazy gits who want their work done for them with no brain engagement required. If you want to learn how to code VBA I'm more than happy to help, anyone who shares my love of logic loops and other geeky things is more than welcome to pick my brains. However, if you want things done for you with no effort on your part then......hire a VBA developer. I'm a VBA developer and my daily rate is around £350. Hint frikkin hint.
    I think it raises an interesting, almost philosophical question about being able to generate code in a much simpler way. Why shouldn't a Macro Recorder+ be designed to simplify even more the creation of code. After all that's what all programming languages do to some extent or another in order to end up with binary machine code.

    Just one suggestion but maybe the recorder could offer prompts for what should constitute a range that needs to be operated on. So instead of capturing an absolute A1 range as now it could perhaps prompt for a range name and any modifier like say the CurrentRegion property.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  133. #133
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,160

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Maybe I've missed something since I've not read all 100+ threads but that doesn't appear to be the case given that Bellygas posted only 3 days ago? And the name certainly doesn't feature in the list of banned users.
    Ooops! My mistake. You are right: the banned member was another doing something very similar. Sorry for the confusion!

  134. #134
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Richard Buttrey View Post
    . Why shouldn't a Macro Recorder+ ...
    It is often said by a lot of Experieced people that the Macro recorder is really useful, - was also said in this Thread. Certainly I encourage new users to learn it how to use it. So you can understand the original Thread Point, - an awfal lot can be got from a Recording done when manually doing what you want a code to do....

    Many of the modifications usually sensible to make to a code produced by the recorder , like removing the Select stuff and replacing Active stuff with a specific referrence are so common, such that an inteligenter Macro Recorder+ certainly seems a good idea..
    I think any help to get a good understanding of the whole way Excel handels relative and absolute referrencing and extending a referrence over an increasd cell range, at an early stage would be very helpful also****, so an inteligent Macro Recorder + to ask about what is wanted in that respect, as Richard suggested, woulld be very helpful.
    I guess that sort of improvement should be possible in a new XL version, - I cannot imagine any backwards compatibility issues ??






    **** https://teylyn.com/2017/03/21/dollar...1/#comment-191
    Last edited by Doc.AElstein; 04-01-2017 at 08:36 AM.

  135. #135
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    My VBA skiils are limited so I rarely offer any VBA help but I do follow threads to learn. For me this forum serves 2 purposes: to give help where I can and to learn where I can't help.
    On the Macro recorder, I use it often to get the base code which I can then modify

  136. #136
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,362

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    To be fair, "macro recorder" is a bit of a shortcut, or even a misnomer, in that it produces a recorded macro based on key strokes. That is, you select a cell or range, or whatever, and you carry out an action. Hence the .Select and subsequent Selection.

    What would be useful is a post processor which could note such constructs and eliminate them. Probably not as easy as it sounds given varying indentations, etc.

    As I've probably said elsewhere on several occasions, I use the macro recorder to get the basic constructs for actions I am less familiar with.

  137. #137
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,960

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    ...one thing I've never understood is why the designers of the macro recorder decided it was necessary to include all the default - usually False, parameters.

    The Print macro code that's captured is a classic example. Rarely do I need to use any True parameters and therefore I end up deleting all the defaults in order to speed up the code.

  138. #138
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    macro please? -you too lazy to use the recorder?or dont you know how, Matey Boy (or Girly?

    Quote Originally Posted by Richard Buttrey View Post
    .....never understood is why the designers of the macro recorder decided it was necessary to include all the default - ...
    I didn’t quite follow Trevor’s point. As I understood there is very little design as such and I thought it somehow just recorded what was being done. Similarly it records on taking any action or adjusting anything the actual snap shot of all the settings after hitting Enter. ( At least that is what I ass-oomed *** ) So the full set of possible arguments are just recorded as they stand at that point in time. Hence you get all parameters even the default / True ones. It would be part of your macro recorder + idea I expect , as a more intelligent recorder , to get rid of those things. ( *** In many actions we take with the recorder running, the recorder waits until we hit Enter then it takes in ( records ) all the stuff we may have filled in, in, for example a dialogue box, and at the same time takes in all the other options we did not change or check / uncheck etc... )

    Sounds like a Macro recorder + could be a bit tricky. Usually Excel is very good at guessing correctly. But for a longer code recording it might make a bad mistake. I guess it might need to test run itself and if it caused some errors it might need to guess again.. and again.. which could get a bit messy. We are still at the point were Humans are needed to sort out a computer programming mess I think.

    If there was a macro recorder + , which I think is a great idea, then I would be keen to still have the present one as well. I find it very good in learning, or for saving you having to clutter your brain with memorising too many things: For one thing it is the arguments, and as Trevor said, the basic constructs, that often , even much later in your career, you are glad to get quickly from a quick, short macro recording. In this case you would probably want it to give you exactly what is there, rather than a guessed modification.


    I always say to an OP that we have to “see” , so select things in order to do stuff in Excel. Hence a simple recording of our actions contains a lot of Activateing and Selecting and doing stuff with the Selection. I then go on to say that Excel does not need that. It can get most of its information from a Range object, and do what you want to do, by making changes to Range objects. So then that leads on nicely to explaining to the taking out of those Activate/ Select and With Selection bits, and modifying the code as such so that it deals directly with the ranges that were being seen and selected by me as I performed actions when the recorder was running.

    If there was a macro recorder + as well then so much the better_.....
    _..... Then when an OP comes with a request that looks like he .. needs a macro that is so simple it could be written with the macro recorder so that you would think the OP was too lazy to do it , but might not know too well the macro recorder.........
    ... you could say, “..Hey !, , sounds like the macro recorder could be great at getting your code there.. !! ......” _...
    _................[ - then you click on the “ how to do a macro recording”.. canned reply in the Canned Replies drop down box to paste those instructions in - ] _..... then you say _.....
    _...“ Try out the macro recorder and macro recorder + , see how you get on , have a go at modifying the code a bit , then if you still have problems post the code you have ( in code tags ) and explain in as much detail as you can where there problems lie, then someone will help you further. ......

    _. The OP likely won’t understand a word , but no matter, then try again and click on the canned reply written in Telugu and maybe you will get further
    Alan
    Last edited by Doc.AElstein; 04-02-2017 at 04:28 AM.

  139. #139
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,960

    Re: macro please? -you too lazy to use the recorder?or dont you know how, Matey Boy (or Gi

    I saw a MacroRecorder+ as being in addition to the current version since as has been remarked it is extremely useful to be able to capture all the syntax that's available which is a vital tool in starting to understand macros. I say in addition but the current recorder could contain a pop up parameter when the 'Record Macro' button is pressed which asks if the user wanted the basic version or the + version.

    As well as capturing key strokes the + version should be able to detect which objects are available and permit the user to open any UserForms or other objects that are available. Then a logical extension would be for the recorder to ask the user (or somehow work out for itself) whether an object or cell needed to be populated with a variable and if so prompt the user to define and then set the variable value.
    Last edited by Richard Buttrey; 04-02-2017 at 05:27 AM.

  140. #140
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Richard Buttrey View Post
    Just one suggestion but maybe the recorder could offer prompts for what should constitute a range that needs to be operated on. So instead of capturing an absolute A1 range as now it could perhaps prompt for a range name and any modifier like say the CurrentRegion property.
    The macro recorder in my excel has an option to use relative references rather than A1 notation. So that's a step.

  141. #141
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,960

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Raphaelp View Post
    The macro recorder in my excel has an option to use relative references rather than A1 notation. So that's a step.
    Thanks for pointing out the obvious. I'm ashamed to say in the hundreds of times I've probably used the recorder I've never noticed that. A case of familiarity breeding contempt I think

  142. #142
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    macro from macro recorder? careful about your Notaions, and relative and absolute thingIES

    Hi Raphaelp, Hi Richard
    Quote Originally Posted by Raphaelp View Post
    The macro recorder in my excel has an option to use relative....
    I think It was one of the first things I read in an old book on VBA, ::_..
    _..and I see it daily, _..
    ViewRelRec.JPG http://imgur.com/gsnt4zM
    DevToolsRelRec.JPG http://imgur.com/XgwxabR
    _.. but forgot about it !!!
    _. Most blogs on the macro recorder show it, but I have not seen any comment on it EasyRecord Macro button DevTools.JPG http://imgur.com/EwmeSK0 http://www.excel-easy.com/vba/exampl...-recorder.html
    Alan


    P.s. Raphaelp
    P.s. 1) You can swap from one to the other as you go along.. ***This code I got from a macro recording. I changed to relative recording in the middle of what I was doingg, ( I added 'comments, but the code I have not changed. The code is what the macro recorder gave me )
    Please Login or Register  to view this content.
    ( Note in passing that you can remove .Range("A1") in that code snippet above and it has no effect – you are not referring to cell A1, you are using the Range(“ “) Property of A1 relative to where you are, ( If you had B1 instead there, that would take you one across from where you was ( which is M20 ) to cell N20. You see the macro recorder is doing a sort of relative referencing with A1 Relative to where you are – which is where you are, relatively speaking, as I am, as it was, the macro recorder was.... relatively speaking, recording stuff, relatively , ...So .Range("A1") Property is redundant
    Might be worth just taking time to look at this again, - it is worth getting it straight, in my opinion. Try this:
    _ Without Use Relative Recording selected, start a macro recording. Select some cell in active worksheet , say cell K20. Now select cells K20 through L21. absoluteRecordingK20L21.JPG http://imgur.com/ZNLIzfw As possibly expected, the macro recorder gives you the last selection before you did anything to the selection, and just returns a single line of Range("K20:L21").Select . Stop the recording. ( Code Makro8 below is what you should get )
    _ Now , select again cell K20. Now select Use Relative Referencing and start a macro recording. Now select cells K20 through to L21. If you are fairly new to Excel, then you might be surprised by the result here of what the recorder gives you: ActiveCell.Range("A1:B2").Select . Important to remember here is that that last code line is returns the Range object related to cells K20:L21, not A1:B2. In the macro I got from this second recording ( Makro9 ) , I have added a few lines just to demo that. ( .. and ## I did a quick demo on something else I explain later as well )
    Please Login or Register  to view this content.

    P..s. 2) Excel is quite good at confusing with how it words these sort of things

    2a) It labels one as macro recording / Record Macro and the other as relative recording / Use Relative References. You would have thought that should say something like relative macro recording and absolute macro recording. ***. Note to switch between absolute and relative recording you toggle the relative recording button. I suppose technically you are switching relative on and off, that is why they label it as they do. But really you should be able to toggle between the two buttons one for relative recording and one for absolute recording, as that I think is what you are doing .... absolutely, or relatively recording ( You will note also that to get relative recording from the start , then you must hit the Record Macro button first or after you select Use Relative References. So indicating that Excel is somehow thinking that it is an additional thing, which seems strange)


    2b) Excel is very silly using
    A1 commonly for “Column letter and row number notation”
    and
    R1C1 commonly for “Row number and column number notation”

    A1 is actually relative referencing for/ To the first cell in “Column letter and row number notation”
    and
    R1C1 actually is absolute referencing for / To the first cell in “row number and column number notation”
    Quote Originally Posted by Raphaelp View Post
    .... relative references rather than A1 notation. So that's a step.
    Be careful not to confuse
    Notation
    And
    Referencing ( absolute and relative )

    There are two forms of notation used in cell referencing

    “Column letter and row number notation”

    and

    “Row number and column number notation”

    Both these displayed notations can represent relative and absolute referencing. In the last code , Makro 9, ## I demoed this by giving you two message boxes. The first uses column Letter and row number notation. The second message box uses row number and column number notation. For both, I selected absolute referencing for the row, and relative referencing for the column

    https://teylyn.com/2017/03/21/dollarsigns/#comment-191
    https://www.excelforum.com/developme...ml#post4618975
    https://www.excelforum.com/developme...ml#post4608252


    P.s.3 )
    Actually in our discussions here “Relative Referencing” is , I think , mainly referring to the use of the .Offset Property to return us a new Range object based on the Range object to which it is applied shifted a specific number of ( rows, columns ). This of course is another thing again. Well not really, relatively speaking: A Relative Thingies it is.
    Last edited by Doc.AElstein; 04-04-2017 at 02:53 AM.

  143. #143
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by Richard Buttrey View Post
    Maybe I've missed somethimg since I've not read all 100+ threads but that doesn't appear to be the case given that Bellygas posted only 3 days ago? And the name certainly doesn't feature in the list of banned users.

    Woah back, woah back. I've been banned....?

  144. #144
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,960

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by BellyGas View Post
    Woah back, woah back. I've been banned....?
    No no. Fear Not.

    See #133

  145. #145
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by BellyGas View Post
    Woah back, woah back. I've been banned....?
    We are talking about a Post/ New User, _.:-

    A new User started a Thread in which he was offering to pay for help with some Excel Work.
    In post # 127, Raphaelp gave you a link to that Thread post.
    But that post and Thread has since been deleted.
    I do not know what happened to that new User. I cannot remember his name.
    Alan

  146. #146
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Good good, I can go back to whinging about bloody foreigners then, er...I mean our overseas friends.

    I actually got an "oh yeah, good idea" today from someone I told to try the macro recorder....there's hope for em.

  147. #147
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Classic example I guess of not knowing whether the guy is being a really lazy ### and just can't be bothered .. or just does not understand a word anyone is saying ... difficult to know I guess ...
    https://www.excelforum.com/excel-gen...at-a-time.html
    Last edited by Doc.AElstein; 04-11-2017 at 05:39 AM.

  148. #148
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,160

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    He understands all right. There was a post he made in that thread which he subsequently edited, in which he claimed only to have posted that query on this forum and nowhere else. He retracted that as soon as I posted the evidence. As he was unwilling to comply with the request I made, I closed the thread.

  149. #149
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Quote Originally Posted by AliGW View Post
    ...There was a post he made in that thread which he subsequently edited, in which he claimed only to have posted that query on this forum and nowhere else. He retracted that as soon as I posted the evidence....
    Ahh that's different - certainly deserved to have his ( or her ) botty smacked
    ( I thought new OPs could not edit , - or I am probably confusing with another Forum where that is the case ? )
    Last edited by Doc.AElstein; 04-11-2017 at 05:48 AM.

  150. #150
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,247

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    As to original topic, I don't think the OP needs to worry too much there are plenty of us £0 people to answer the really dumb questions
    Unless the asker is rude too too demanding - in which case he can do it himself.

  151. #151
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Hi scottiex,
    Quote Originally Posted by scottiex View Post
    As to original topic, I don't think the OP needs to worry too much..Unless the asker is rude too too demanding - in which case he can do it himself.
    As to the original OP/s that prompted the Thread.. I answered him/her and many similar for I guess getting on for well over a year.
    Dumb questions are not always too bad – an OP might be at the level of not knowing what / how to ask, having no idea what / how his answer could be answered – I think we have all been there ourselves.
    As for very demanding questions.... If you’re learning / not too clued up, but wanting to help you may find more often answering the more demanding from “work” to be done, but less technically demanding. Feedback in those cases can be quite bad, but if you want to / enjoy learning and enjoy answering Excel questions then go for it.
    From a learning point it can be great. I doubt most of us could ever learn all there is in something like Excel / VBA.

    It is probably in everyone’s benefit though to try and “steer” the “bad” OPs a bit in the direction of being “better”, but it is very difficult to do that politely sometimes.. I think you really need to try that though... or they will probably come back worse ... which is bad for everyone in the long run
    Alan



    EDIT P.S. Here ia another recent Thread on OPs and coutesy
    https://www.excelforum.com/the-water...ps-and-qs.html
    Last edited by Doc.AElstein; 04-26-2017 at 02:26 AM.

  152. #152
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,247

    Re: "I need a macro that is so simple it could be written with the macro recorder...."

    Yes I very much agree Alan,

    Although by demanding I mean when they start to complain that you are not answering quickly enough or otherwise start treating you like their employee. I think if you come to a website like this you have a duty to be very polite to the person who is doing you a significant favour and no right to complain if they drop you like a hot potato for being rude.

    I know I am grateful for any assistance I get on here even if it only gets me one step closer to my solution because that is still a lot better than no steps closer and it is great to know there are people out there willing to help you just for the sake of being helpful (and for the sake of a well deserved click on that add reputation star!).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. Help?? After I run a macro, cells with "macro-formulas/functions" show "#VALUE!"
    By de_keda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2015, 11:08 AM
  3. "Coloring macro" and a "copy if cell contents are .." macro are interfering
    By dreddster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2015, 08:30 AM
  4. [SOLVED] Can I combine a simple "clear" macro with another that clears checkboxes?
    By Maezee in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-22-2013, 01:30 PM
  5. Can't set "Fit to Page" in simple VBA macro
    By finny388 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2011, 10:02 PM
  6. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  7. Replies: 0
    Last Post: 07-17-2006, 09:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1