+ Reply to Thread
Page 9 of 11 FirstFirst ... 7 8 9 10 11 LastLast
Results 121 to 135 of 152

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

  1. #121
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2007 2010 PC but Not mac. XP and Vista mostly
    Posts
    3,382

    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.
    '_- 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 )

  2. #122
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2007 2010 PC but Not mac. XP and Vista mostly
    Posts
    3,382

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

  3. #123
    Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    340

    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.

  4. #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
    40,461

    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
    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 some-1 helped you

    Regards
    Ford

  5. #125
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2007 2010 PC but Not mac. XP and Vista mostly
    Posts
    3,382

    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.

  6. #126
    Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    340

    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.

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

    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

  8. #128
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2007 2010 PC but Not mac. XP and Vista mostly
    Posts
    3,382

    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?

  9. #129
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2010 (Win 7 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    7,287

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


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  10. #130
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2007 2010 PC but Not mac. XP and Vista mostly
    Posts
    3,382

    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.

  11. #131
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2010 (Win 7 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    7,287

    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!

  12. #132
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    21,604

    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.

  13. #133
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2010 (Win 7 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    7,287

    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!

  14. #134
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2007 2010 PC but Not mac. XP and Vista mostly
    Posts
    3,382

    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.

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

    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

+ Reply to Thread
Page 9 of 11 FirstFirst ... 7 8 9 10 11 LastLast

Thread Information

Users Browsing this Thread

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

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