+ Reply to Thread
Page 1 of 2 1
Results 1 to 200 of 298

Call in the Cavalry - 2015

  1. #1
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Call in the Cavalry - 2015

    2015- Happy New Year
    http://www.excelforum.com/the-water-...4-onwards.html

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2015 onwards

    could you make it sticky please
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Call in the Cavalry - 2015 onwards

    Quote Originally Posted by martindwilson View Post
    could you make it sticky please
    All done - Now stuck
    Audere est facere

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Re: Call in the Cavalry - 2015 onwards


  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Re: Call in the Cavalry - 2015 onwards

    Anybody else have problems getting McG's wb to work?
    http://www.excelforum.com/excel-prog...condition.html

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015 onwards

    Anyone have a look at this, please.

    Lookup functionality from a group against a matrix

    I have no idea what to do with it.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    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


  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    OP facing automatic De-selection in excel when connected to internet. Any suggestion will be helpful to the OP

    http://www.excelforum.com/excel-gene...bug-in-xl.html


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Call in the Cavalry - 2015

    OP is running MAC. UDF works for me on Windows machine. OP cannot get to work. Any thoughts out there?

    http://www.excelforum.com/excel-prog...same-time.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  9. #9
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,776

    Re: Call in the Cavalry - 2015

    I see you're pursuing alternatives but the issue was that
    Please Login or Register  to view this content.
    won't work on a Mac.
    Everyone who confuses correlation and causation ends up dead.

  10. #10
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Call in the Cavalry - 2015

    This one will require a UDF or VBA

    http://www.excelforum.com/excel-form...in-a-cell.html
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

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

    Re: Call in the Cavalry - 2015

    Is it possible to count consecutive dates in unsorted data? (with a criteria)

    I've tried a few VBA loops as well as standard formulas. https://www.excelforum.com/showthread.php?t=1060307
    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!

  12. #12
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Call in the Cavalry - 2015

    Anyone up for a challenge. OP is looking to do a search using one identifier that indicates multiple field criteria. I am baffled.

    http://www.excelforum.com/excel-prog...arch-code.html

  13. #13
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Re: Call in the Cavalry - 2015

    Can somebody look at this, I have run out of time.
    http://www.excelforum.com/excel-prog...ml#post3958290
    The code works for me, it creates a formula from closed workbooks, then renames the workbooks as whatever the formulas are.

    Thanks.

    I should add, the code just works once, running it a second time results in error when writing the formula.
    Last edited by davesexcel; 01-16-2015 at 08:54 AM.

  14. #14
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Anyone have a look at this ...

    Downloading Visio and connecting to excel 2007

    Started out looking for generic advice on which version of Visio to download.

    Now it seems to be a problem automating Outlook.

    Welcome any input/thoughts.

    Thanks, TMS

  15. #15
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,622

    Re: Call in the Cavalry - 2015

    It is a real nice, challenge one which I have spent couple hours, but could not give it an end.

    Start and End calculation is finished, though it is sure that there must be better solution somewhere.

    Also, I am stuck in Total cell (cell I4).

    Can somebody look at this and give an end?

    http://www.excelforum.com/excel-form...tal-hours.html
    Quang PT

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

    Re: Call in the Cavalry - 2015

    This poster needs help with a pivot table:

    https://www.excelforum.com/showthread.php?t=1061056
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  17. #17
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    I am unable to understand this OP's actual problem (Date Format)

    http://www.excelforum.com/excel-prog...or-format.html

  18. #18
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,776

    Re: Call in the Cavalry - 2015

    Would somebody else like to have a go here: http://www.excelforum.com/excel-char...ct-result.html ?

    I need to step away for a bit.

  19. #19
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Call in the Cavalry - 2015

    A VBA solution would be much better for this.. the two threads are linked of course

    http://www.excelforum.com/excel-gene...ml#post3958138
    http://www.excelforum.com/excel-gene...ed-lookup.html
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  20. #20
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-char...et-advice.html The OP says he is having trouble implementing the solution in 2013. Not knowing what might be different between 2007/2010 and 2013, can anyone look at the tutorials and identify any obvious "here's where 2013 is different" steps?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  21. #21
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Can someone have a look at this. I've lost the plot.

    Use Cell Formula in VBA code


    Thanks, TMS

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

    Re: Call in the Cavalry - 2015

    I'm thinking this might be a SUBTOTAL trick of some kind... http://www.excelforum.com/excel-form...ml#post3963902
    _________________
    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!)

  23. #23
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    Workbook open event is not working in this OP's colleague machine (VBA)

    I am unable to fix the issue so any suggestion will be helpful to the OP.

    http://www.excelforum.com/excel-prog...alization.html

  24. #24
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    This person is stuck building a "heat map" using one of Chandoo's templates: http://www.excelforum.com/excel-gene...-map-help.html

    It appears that his hangup is around adapting Chandoo's 5x5 table to the OP's 10x4 table. Since Chandoo's tutorial depends on the use of structured table references (and I,, stubbornly, do not want to learn structured table references today), I do not know how to adapt structured table references and named ranges using them from 5x5 to 10x4. Can anyone step in and help?

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

    Re: Call in the Cavalry - 2015

    Can I get a little backup on this:

    http://www.excelforum.com/excel-prog...-workbook.html

    User requests a Command Button macro that modifies a single cell on multiple workbooks with similar names in the same folder.

    I started on this on Tuesday and am still out of the office with the flu.

  26. #26
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Call in the Cavalry - 2015

    Hi guys. Can someone help me (and the OP) with this one. OP was trying to retrieve data from one workbook to anther. I gave them a solution using indirect but it seems indirect only works on OPEN workbooks. Can someone look at it and see if there is a formula solution to this for CLOSED workbooks?

    thanks

    http://www.excelforum.com/excel-form...yperlinks.html
    Happy with my advice? Click on the * reputation button below

  27. #27
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    Anyone want to chime in on this 1?

    http://www.excelforum.com/excel-prog...ml#post3977955
    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

  28. #28
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Call in the Cavalry - 2015

    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  29. #29
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-prog...ml#post3981394

    I'm not sure what OP means by "automatic scrolling" - and to be honest, I don't have the energy to begin explaining about the options of looping through selecting / delay which is the approach that springs to mind. Not sure what he's actually aiming to achieve. Anyone?!
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  30. #30
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Re: Call in the Cavalry - 2015

    Anybody want to look at this, my head hurts.
    http://www.excelforum.com/excel-prog...ml#post3948177

  31. #31
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    I don't have any clue how some of the row numbers disappear from excel worksheet

    But I suspect some addin may caused this issue

    Any suggestion will be helpful to the OP

    http://www.excelforum.com/excel-gene...ml#post3983077

  32. #32
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    can anyone help with this? I think it fell through the cracks...
    http://www.excelforum.com/excel-prog...worksheet.html

  33. #33
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    I have probably gone just about as far as I can realistically go with this one: http://www.excelforum.com/excel-char...ock-chart.html

    I know how to make a panel chart without VBA, but he seems to want to do it all in VBA. Since I never use VBA to create charts (and am too lazy to learn it just for this one post), I'm calling on others who may be more conversant with manipulating charts with VBA to help him out with the code details he gets stuck on.

  34. #34
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    I don't know how better I can help this guy, anyone please take care this thread... (VBA)

    http://www.excelforum.com/excel-prog...ers-value.html

  35. #35
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    Excel function not working after converting the File to Dutch Version

    Any suggestion will be helpful to the OP

    http://www.excelforum.com/excel-form...g-formula.html

  36. #36
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-prog...uaranteed.html

    please check the attached with xl'03

  37. #37
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Subscript Out Of Range Error

    Anyone care to cast their eyes over this, please:

    Subscript Out Of Range Error

    Not sure of the purpose of this code but not for me to question. If I have understood what it does and how it does it, it should work. But, in some cases, it doesn't.

    Thanks for any input, ideas and thoughts, TMS

  38. #38
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Call in the Cavalry - 2015

    Hi all.

    Apologies if it seems like I'm asking for help on my own post, but would just appreciate if, on top of what Mr Shorty's said, someone with Excel 2010 could verify if they get the same results as I do:

    http://www.excelforum.com/excel-form...-0-errors.html

    Thanks a lot
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  39. #39
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    Form Visual Effect is happening in the end of the code only not while the code runs (VBA)

    Any suggestion will be helpful to the OP

    http://www.excelforum.com/excel-prog...-continue.html

  40. #40
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2015

    I'm unable to understand the OP's requirements here

    http://www.excelforum.com/excel-prog...ank-order.html

    Can you please help?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  41. #41
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    Here's one that is extending beyond my union approved job description: http://www.excelforum.com/excel-char...iple-axes.html

    I believe the filter or pivot approach will work just fine, but the OP does not want to "click away from the chart" to execute changes to the pivot table or filter. My only thought is to automate the pivot or filter changes through macros associated with buttons on the chart. However, as noted, that goes beyond what I can do or want to learn how to do at this point.

  42. #42
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    Can anyone help here? I can get it to work if the dates are always Sat or Sun, but they are not always...
    http://www.excelforum.com/excel-form...ml#post3992416

  43. #43
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    This guy has a working solution, but he seems to dislike his helper columns. Since I am one who prefers to use helper columns, I am suggesting that one of you who is much more keen on eliminating helper columns would step in and help eliminate the helper columns.

    http://www.excelforum.com/excel-form...ial-value.html

  44. #44
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    The OP here marked solved before I could call in the cavalry. I have sometimes wondered about this as well, so, even for my own education, is there a way to code a VBA UDF so that Excel will automatically recognize the output type and change the number format accordingly? http://www.excelforum.com/excel-prog...s-in-udfs.html

    I have seen this behavior with native date and financial functions, where if you put =TODAY() or =PV() into a cell formatted as general, Excel will recognize that "data type" of the function and format the cell for you (whether you like it or not). Can we code a VBA UDF in such a way to get similar behavior, or will it necessitate "change event" procedures and such to force the issue.

  45. #45
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

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

    Re: Call in the Cavalry - 2015

    I'm having trouble interpreting the data here - can you please take a shot at it?
    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

  47. #47
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Re: Call in the Cavalry - 2015

    Can somebody check this out and see if it is an xl'07 issue.

    http://www.excelforum.com/excel-prog...ml#post4002083

  48. #48
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    OP claiming that OS Windows XP / 7 is causing Printing Problem in Excel.

    I am unable to fix the issue so any suggestion will be helpful to the OP

    http://www.excelforum.com/excel-gene...g-problem.html

  49. #49
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    OP is using some sort of calculation but I don't know how he is arriving it

    Anyone please take this thread

    http://www.excelforum.com/excel-gene...a-dataset.html

  50. #50
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    OP asking if the Find/Replace window can be anchored, not sure if there is a VBA way to do this?

    http://www.excelforum.com/excel-gene...ce-window.html

  51. #51
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    OP in need of HTML Web Query in VBA to search Website and Get the Resulting Value in excel Cell (may be UDF with HTML object query I think)

    Any suggestion will be helpful to the OP

    http://www.excelforum.com/excel-prog...ml#post4006558

  52. #52
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,326

    Re: Call in the Cavalry - 2015

    Anybody want to bite on a formula here...

    http://www.excelforum.com/excel-form...umproduct.html
    HTH
    Regards, Jeff

  53. #53
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Call in the Cavalry - 2015

    I would really appreciate if someone could assist with providing a VBA solution to the OP. The formulas that were provided work however, over 65,000 rows makes the task impossible to accomplish.

    Thank you.

    http://www.excelforum.com/excel-gene...g-problem.html
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  54. #54
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,326

    Re: Call in the Cavalry - 2015

    Could somebody with more VBA experience than I offer a suggestion here?

  55. #55
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,326

    Re: Call in the Cavalry - 2015

    This VBA request I don't quite understand. Any Takers?

  56. #56
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Anyone provide ideas and inspiration for this:

    http://www.excelforum.com/excel-gene...d-in-tab1.html

    The OP has multiple sheet that have replicated data using INDIRECT. There is an issue when rows are added or deleted. I have suggested using INDEX but that, seemingly doesn't provide the solution being searched for.

    Thanks, TMS

  57. #57
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Mental block on this ... just can't see what the OP is asking for.

    http://www.excelforum.com/excel-prog...mpty-cell.html

    Anyone care to take a look?

    Thanks, TMS

  58. #58
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

  59. #59
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    I don't know what this OP want me to do

    http://www.excelforum.com/excel-new-...uplicates.html

  60. #60
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-gene...ml#post4017210

    OP is trying to work on something to track food eaten with "bad" symptoms. I have started on something here, but if anyone else has any input, that would be great, I would hte to re-invent the wheel

  61. #61
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Anyone care to take a look at this one:

    http://www.excelforum.com/excel-new-...err-clear.html

    Ideally, someone who has a deep understanding of error trapping and handling.

    I know, and so does the OP, various ways of avoiding this issue, but that's not the point. The OP is using "On Error GoTo Here" to switch on error handling. But it doesn't seem to handle the error generated when Application.WorksheetFunction.Match doesn't find the search value. We both know that it can be avoided using "On Error Resume Next", and I have explained that it can also be avoided by using just Application.Match. Again, not the point he is making. Why doesn't "On Error GoTo Here" work?

  62. #62
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    Mysterious Result by Iferror() unable to fix the root cause

    http://www.excelforum.com/excel-form...to-defeat.html

  63. #63
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Call in the Cavalry - 2015

    Does anyone have an idea what the OP is trying to do here?

    http://www.excelforum.com/excel-prog...e-not-set.html
    If posting code please use code tags, see here.

  64. #64
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

  65. #65
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-prog...using-vba.html

    The OP PM's me requesting help. I didn't feel that I could help him. When he bumped his thread, he asked if I knew anyone who could help him. I suggested that he might want to post additional details about his requirements, or try to narrow the scope of his question down to something more specific, and that others would be more likely to respond. If anyone here has any suggestions or questions for this OP, you might have a look and see if we can offer anything helpful -- even if it is another question to help him ask a better question.

  66. #66
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Would anyone care to take a look at this and offer thoughts and advice.

    Xltm opens the original not a copy

    The OP is saving a workbook as a template file, but then double clicking on it to open. He says that double clicking on the template opens a copy of the workbook for most users, but not for one of them.

    Strictly speaking, I don't believe that the "template" is being used in the true sense of a template, as Microsoft might consider it. They are simply using the "template" as base copy of the file. Apparently, the users double click on the file and it opens a copy of the file. They create a costing using it and print it out but never save the file.

    I am more than a little confused and would welcome a second, third and fourth opinion.

    Thanks, TMS

  67. #67
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Re: Call in the Cavalry - 2015

    Here's one that has been haunting me for a while.
    http://www.excelforum.com/excel-prog...ot-saveas.html

  68. #68
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    Not sure what this OP wants me to do?

    http://www.excelforum.com/excel-gene...-research.html

  69. #69
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    Simple combination of functions needed to populate result but I am week in maths so unable to understand how the OP arrives the result.

    http://www.excelforum.com/excel-form...ach-value.html

  70. #70
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-form...s-formula.html

    Next request is out of my wheel house. Can this be accomplished with worksheet change event?

  71. #71
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,766

    Re: Call in the Cavalry - 2015

    Hmmm.. I'm also interested how formatting can change values in the chart:

    http://www.excelforum.com/excel-gene...kes-sense.html
    Never use Merged Cells in Excel

  72. #72
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Call in the Cavalry - 2015

    Anybody want to help someone do a waterfall chart?

    http://www.excelforum.com/excel-char...tter-idea.html
    Entia non sunt multiplicanda sine necessitate

  73. #73
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.90 for Mac MS 365
    Posts
    8,583

    Re: Call in the Cavalry - 2015

    I think this poster needs VBA and that isn't in my wheelhouse. Anyone who can help him?

    http://www.excelforum.com/excel-form...l-a-value.html
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  74. #74
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Call in the Cavalry - 2015

    Any thoughts on this issue. I am at a loss at how to even formulate in my mind. Need to look at OPs last post to understand what he wants.

    http://www.excelforum.com/excel-gene...n-workbks.html

  75. #75
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,622

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/showthread...=1#post4043652

    Any help to draw data from table?

  76. #76
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    I am unable to fix which one is causing Automation Error (VBA)

    http://www.excelforum.com/excel-prog...s-clients.html

  77. #77
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    Hyperlink created in 2013 on a shape is crashing when the file is opened in 2010 while clicking the shape

    Any suggestion will be helpful to the OP

    http://www.excelforum.com/showthread...=1#post4046341

  78. #78
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    Anyone would like to take this maths question?

    http://www.excelforum.com/excel-prog...n-and-row.html

  79. #79
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-prog...in-a-cell.html

    Long and confusing and mac, if anybody wants to take the time.

  80. #80
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-prog...with-data.html

    Scope creep has taken this beyond my capabilities.

    Alan

  81. #81
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    @Alan: answered in thread.

    Regards, TMS

  82. #82
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Call in the Cavalry - 2015

    @Trevor

    Thanks. I could not wrap my head around the last request.

    Alan

  83. #83
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    You're welcome. Let's hope it works in the live environment. Basically, for blank cells in columns B to D, it propagates whatever is to the left, including blanks. Initially it applies a formula and then converts the formula result to a value. That way, you end up copying across but still have blank cells. Then, for the blank cells in row 10 down, it propagates whatever is above. Same approach, formula then value.

    If the "rules" are the same in the live environment, it should be OK.

    Cheers, Trevor

  84. #84
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Please, please, please ... can someone take a look at this and see if they can explain it in a different way.

    Took me a while to see the issue, out of context, but with the code and the workbook, it is more obvious.

    However, I just don't seem to be getting it across to the OP. Maybe it's me, it could very well be me, but I really can't say it a different way ...

    Thanks to anyone with more patience than me

  85. #85
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by TMS View Post
    Please, please, please ... can someone take a look at this and see if they can explain it in a different way.

    Took me a while to see the issue, out of context, but with the code and the workbook, it is more obvious.

    However, I just don't seem to be getting it across to the OP. Maybe it's me, it could very well be me, but I really can't say it a different way ...

    Thanks to anyone with more patience than me
    Something is missing

  86. #86
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Call in the Cavalry - 2015

    Hi,

    Can your amazingly genius minds help me solve my requirement in my thread Partial Match for Group Names ?
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  87. #87
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,776

    Re: Call in the Cavalry - 2015

    The purpose of this thread is not for you to bump your own questions. It's for when you get stuck trying to help someone else.

  88. #88
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    ANyone feel like jumping into this 1? Looks fairly interesting - creating a dynamic pic from an excel range.

    http://www.excelforum.com/excel-gene...t-in-list.html

  89. #89
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    I've got this OP started: http://www.excelforum.com/excel-char...bar-chart.html but he wants to create his counts using a pivot table, and pivot tables/charts are above my pay grade. Can anyone step in and help with the pivot table creation?

  90. #90
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Call in the Cavalry - 2015

    You've got to learn Pivot Tables mate, I reckon they're the single most useful thing in Excel!

  91. #91
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    I wouldn't ever use pivot tables/charts in my regular work -- only here on the forum. That said, I am slowly learning them. It wasn't that long ago that I would not have even recognized that the OP's question naturally fit into what a pivot table can do. I think I am making wonderful progress just starting to recognize the kind of problems that can be solved using pivot tables.

  92. #92
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Posting this to raise awareness of the thread and the issue.

    http://www.excelforum.com/excel-form...on-2014-a.html

    Maybe plus rep to show support?

  93. #93
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,504

  94. #94
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2410
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Would somebody look at this one.

    I've proposed that a VBA solution is what OP needs. I don't trust myself VBA. I've taken this as far as I can formula wise. OP inherits data in multiple sheets and must make summary sheet(s) of their own from that data.

    http://www.excelforum.com/excel-form...ata-is-in.html

    Thanks,
    FR

  95. #95
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    @FlameRetired: VBA solution provided. This consolidates the monthly data into a single worksheet and then bases the calculations on that sheet. It uses SUMPRODUCT with several Dynamic Named Ranges.

    Regards, TMS

  96. #96
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2410
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    @TMS
    Thank you for looking into this. It was way above my pay-grade.

  97. #97
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    @FlameRetired: Me too, once. But, you practice, you get better

  98. #98
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    I have, once again, got myself into a question that turns out to be more about pivot tables than what the original question suggested. The OP has not been able to upload a sample spreadsheet, but can anyone step in and suggest how to get his pivot table to pull out the data he needs? I expect that, once we know how to get the data from the pivot table, creating the chart will be easy.

    http://www.excelforum.com/showthread...56#post4071656

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

    Re: Call in the Cavalry - 2015


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

    Re: Call in the Cavalry - 2015

    @ Tony - not really, the rule of thumb is to not expect a function to actually DO anything

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

    Re: Call in the Cavalry - 2015

    But go ahead and break that rule if you really want

    http://www.excelfox.com/forum/f22/br...unctions-1519/

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

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by xladept View Post
    @ Tony - not really, the rule of thumb is to not expect a function to actually DO anything
    That's what I thought too until someone at some place posted examples of UDFs that do DO stuff!

    Can't remember where or when or what they did.
    Last edited by Tony Valko; 05-15-2015 at 06:03 PM.

  103. #103
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Call in the Cavalry - 2015

    There are a few odd things they can do that I know of: set indent level, add comments, merge and unmerge, add a picture.

    I have examples if you'd like to see them.
    Last edited by shg; 05-15-2015 at 06:35 PM.

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

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by Tony Valko View Post

    Can't remember where or when or what they did.
    Might have been the private MS MVP forum.

  105. #105
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2410
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by Tony Valko View Post
    That's what I thought too until someone at some place posted examples of UDFs that do DO stuff!

    Can't remember where or when or what they did.
    Rick Rothstein posted one that did that. He used some trick with Hyperlink. Looked like a bug squirted across the screen. LOL It's on the Forum somewhere.

  106. #106
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Call in the Cavalry - 2015

    There's an example of indenting with a UDF at http://www.excelforum.com/excel-form...-function.html, and setting a comment at http://www.mrexcel.com/forum/excel-q...reference.html
    Last edited by shg; 05-15-2015 at 08:03 PM.

  107. #107
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2410
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by FlameRetired View Post
    Rick Rothstein posted one that did that. He used some trick with Hyperlink. Looked like a bug squirted across the screen. LOL It's on the Forum somewhere.
    Nope. Found it.....excelfox

    http://www.excelfox.com/forum/f22/br...1519/#post7156

  108. #108
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by scottiex View Post
    But go ahead and break that rule if you really want

    http://www.excelfox.com/forum/f22/br...unctions-1519/
    Isnt that what this post links to?

  109. #109
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2410
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by FDibbins View Post
    Isnt that what this post links to?
    Yup. Sorry. Failed to refresh after searching.

  110. #110
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015


  111. #111
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by FlameRetired View Post
    Yup. Sorry. Failed to refresh after searching.
    haha no problem, been there, done that

  112. #112
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2410
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Would somebody look into this one? OP has 1600 cells of array formula. That seemed OK. Then they requested 4 conditional formats to apply to those same cells. These all seem to require more array formulas. I'm out of ideas.

    http://www.excelforum.com/excel-gene...arge-data.html

  113. #113
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Call in the Cavalry - 2015

    Does anybody know how to connect to Business Objects Central Management Sercer console and extract data ? What are the list of references needed to be added to the Project to connect to InfoStore ?


    Sarang

  114. #114
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,766

    Re: Call in the Cavalry - 2015

    Saarang84, this is The Water Cooler subforum and it's not planned to answer questions.

    more over this is Cavalry thread where we seek help for OTHER members, not for ourselves.

  115. #115
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Call in the Cavalry - 2015

    Could someone have a look at this thread?

    http://www.excelforum.com/excel-prog...-a-button.html

  116. #116
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Call in the Cavalry - 2015

    Once we got over the confusion concerning the nature of the request (VBA not conditional formatting...), I know that I can't help . Can you?

    http://www.excelforum.com/excel-gene...ell-value.html
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  117. #117
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-char...ce-charts.html

    Does anyone know if it is possible (or if it is impossible) to add a 2nd data set to a 3D surface chart?

  118. #118
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Call in the Cavalry - 2015

    Can anyone take a look at http://www.mrexcel.com/forum/excel-q...orrupted.html?

    There is a LOT of code in the workbook MyMacros, but the problem is much simpler: there is a compile error for two controls on one of the forms; the control names appear in Intellisense, but the compiler doesn't like them. CodeCleaner didn't work, which surprised me.

  119. #119
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Re: Call in the Cavalry - 2015

    I looked at: http://www.excelforum.com/showthread...70#post4092670
    Tried helping, but something came up and don't have the time to further help here today.

    Hopefully you can pick it up from here
    Inveniam Viam Aut Faciam

  120. #120
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Call in the Cavalry - 2015

    Hello all
    I've been trying to help the OP here:

    http://www.excelforum.com/excel-prog...-from-url.html

    He wants to display around 900 product images in the workbook but doesn't want to just go to the image URL. Do any of you have any ideas? As regards this I'm at the limit of my knowledge.

    Regards
    DBY

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

    Re: Call in the Cavalry - 2015

    For some reason this demands a reference to Outlook 15. So, I'm stymied?? Hopefully one of y'all can help.

  122. #122
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,776

    Re: Call in the Cavalry - 2015

    Just uncheck the reference and add a reference to whichever Outlook version you have.

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

    Re: Call in the Cavalry - 2015

    @ Rory - that worked! Duhhhhh - Thanks

  124. #124
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2410
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Would somebody have a look at this one. I am stumped. I'm not ever sure this can be done without OP supplies some more structure ...... but I don't even know what it would be.

    http://www.excelforum.com/excel-form...low-input.html

    Edit never mind. I think I've found something that will work.
    Last edited by FlameRetired; 06-14-2015 at 06:55 AM.

  125. #125
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2410
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    This seems to require some knowledge of working with support files. I don't know how. The content is also in French. OP assures us that shouldn't be an issue.

    Would anyone like to take a look at this?

    http://www.excelforum.com/excel-form...rom-scale.html
    Dave

  126. #126
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.90 for Mac MS 365
    Posts
    8,583

    Re: Call in the Cavalry - 2015

    Perhaps someone with a sharper eye and better skills than I have can help this OP... http://www.excelforum.com/excel-gene...-way-help.html
    he needs addresses separated but I don't see any consistency between them that you can use to create a formula to accomplish it.

  127. #127
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    New member needs assistance with Access and Excel...
    http://www.excelforum.com/excel-prog...-database.html

  128. #128
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Call in the Cavalry - 2015

    VBA solution needed. Way beyond me!!

    http://www.excelforum.com/excel-form...omer-name.html

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

    Re: Call in the Cavalry - 2015

    Glenn, when you notice a thread is in the wrong sub-forum, just use the REPORT button on that thread asking a moderator to move it. They can also remove previous posts in a thread to set it back to zero replies so more people can see it on the UNANSWERED THREADS list.

  130. #130
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2015

    @ JB

    I've clicked on that Link several times and have hesitated to use it...it says
    Note: This is ONLY to be used to report spam, advertising messages, and problematic (harassment, fighting, or rude) missing code tags, poor thread titles posts..

  131. #131
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Call in the Cavalry - 2015


  132. #132
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Call in the Cavalry - 2015

    Hi Guys,

    I'm stumped as to why something is not working, because as far as I can tell my code just does what the user would do manually, but the results are not working out. I suspect somehow the macro running interferes with the solver addin, but I haven't ever touched on that so I'm a bit out of my league on solving the discrepancy between manual and automated. If someone could help this guy, you may have some insight on what I'm misssing.

    http://www.excelforum.com/excel-prog...ew-to-vba.html

    When the data is right on the third sheet (which is where the solver works) the results copied are fine onto the 4th sheet, which is intended as "historical" data. But somehow putting in the data and running the solver by calling its macro does not work out.

    UPDATE: No problem anymore.... I missed something obvious... a cell was pointing somewhere else, and I didn't compensate. (Dumb Me )
    Last edited by Arkadi; 06-26-2015 at 08:49 AM. Reason: Figured it out, simple mistake, feel stupid :(
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

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

    Re: Call in the Cavalry - 2015

    Now that I've gotten some off-topic answers in my post, the chances of you gurus seeing the question is greatly reduced. Any help here would be appreciated:

    http://www.excelforum.com/excel-prog...in-memory.html

  134. #134
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    Got a doozy here, chip in if you can. Break out address from a text string....
    http://www.excelforum.com/excel-prog...in-spaces.html

  135. #135
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    I have not used Morefunc yet, if anyone else has, can you offer any suggestions here...
    http://www.excelforum.com/excel-prog...ml#post4115913

  136. #136
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,099

    Re: Call in the Cavalry - 2015

    I took a stab at this one, and it quickly got above my head. I think the question is really more about the logic used in financial calculations and not so much about how to program them into Excel. The functions he is using seem to be calculating correctly. The OP is not sure that the result is really correct, so I suspect someone with a solid financial background (NPV/IRR/cash flow/investment return type problems) to explain whether he is choosing the correct function(s) for the task.

    http://www.excelforum.com/excel-form...r-answers.html

  137. #137
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    Why is this sum(countifs()) not working. It seems to be correct...
    http://www.excelforum.com/excel-form...ml#post4120736

  138. #138
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    Can anyone help the OP with this? It's been almost a month, with not 1 reply

  139. #139
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by FDibbins View Post
    Can anyone help the OP with this? It's been almost a month, with not 1 reply
    Perhaps a link, Ford?

  140. #140
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    hahaha yeah, I think that may help....
    http://www.excelforum.com/excel-prog...f-the-day.html

  141. #141
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

    Re: Call in the Cavalry - 2015

    Easy one, but I am not getting the expected result logic Formula Question

    http://www.excelforum.com/excel-form...ax-number.html

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

    Re: Call in the Cavalry - 2015

    Can anyone help the OP with this? It's been almost a month, with not 1 reply
    Hey Ford,

    That thread is marked solved???

  143. #143
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Call in the Cavalry - 2015

    2 of us have tried this one. Anyone else have any ideas? They are trying to remove the false values form an array so they end up with an array that only multiplies the true values.
    http://www.excelforum.com/excel-prog...umproduct.html
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

  144. #144
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Bookmaker Odds


  145. #145
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Call in the Cavalry - 2015

    Is there something I am missing with the ChangeLink method here?
    http://www.excelforum.com/excel-prog...ink-error.html

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

    Re: Call in the Cavalry - 2015

    I hate to admit I'm a bit stumped by the latest addition to this thread:
    http://www.excelforum.com/excel-prog...ml#post4132288

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

    Re: Call in the Cavalry - 2015

    A thread that looks like it was accidentally abandoned, if anyone is familiar enough with FREQUENCY to jump back in:

    http://www.excelforum.com/excel-gene...ml#post4097016

  148. #148
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,022

    Re: Call in the Cavalry - 2015

    Really interesting problem here. Can you guys offer suggestions?

    http://www.excelforum.com/excel-gene...mbol-mean.html

  149. #149
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Is it just me ... ? This link: http://www.excelforum.com/excel-prog...ard-speed.html

    gives me:


    Database Error Database error
    The Excel Help Forum database has encountered a problem.
    Please try the following:
    Load the page again by clicking the Refresh button in your web browser.
    Open the www.excelforum.com home page, then try to open another page.
    Click the Back button to try another link.
    The www.excelforum.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

    We apologise for any inconvenience.

  150. #150
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Call in the Cavalry - 2015

    I can't get around the error values in this thread:
    http://www.excelforum.com/excel-form...ef-errors.html

  151. #151
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2015

    @TMS

    Not just you...I get the same...actually have had several incidents such as that today...Gremlins...

  152. #152
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2410
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    @TMS
    Is it just me...?
    Nope! I get that occasionally, too. I also get redirected to something called Sucurri (sp?) Cloud. They inform me that the Forum site is down for maintenance. Happens pretty often.

  153. #153
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    @FR: I've had that but this one's a bit different ... a database error for a specific thread. Still doing it

  154. #154
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,776

    Re: Call in the Cavalry - 2015

    Same for me. Trying to access it via http://www.excelforum.com/showthread.php?t=1094694 fails with the same error. Must be something corrupted in the thread content I guess.

  155. #155
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015 => another database error

    Another one ...

    http://www.excelforum.com/excel-prog...or-1004-a.html


    Can't even report it because it just show as:



    Database Error Database error
    The Excel Help Forum database has encountered a problem.
    Please try the following:
    Load the page again by clicking the Refresh button in your web browser.
    Open the www.excelforum.com home page, then try to open another page.
    Click the Back button to try another link.
    The www.excelforum.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

    We apologise for any inconvenience.

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

    Re: Call in the Cavalry - 2015

    It blew me off too

  157. #157
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Interesting turn of phrase

  158. #158
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Call in the Cavalry - 2015

    I had thought of making an even more risque comment... but I managed to control myself....

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

    Re: Call in the Cavalry - 2015

    It's 20th Century American vernacular

  160. #160
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    And what century are we in now?

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

    Re: Call in the Cavalry - 2015

    Hi Trevor,

    Welcome to the 21st century (I thought you knew)

  162. #162
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    That's what I thought ... so I guess you're living in the past

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

    Re: Call in the Cavalry - 2015

    Hey Trevor,

    If Space has three dimensions then why not Time?

  164. #164
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,649

    Re: Call in the Cavalry - 2015

    Ok, you're getting surreal now. And it's not even Doctor Who season

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

    Re: Call in the Cavalry - 2015

    What do you mean "getting"

  166. #166
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Call in the Cavalry - 2015

    create any thread with the words "compile 1004"

  167. #167
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2015

    @vlady

    This is what's causing the issue?
    any thread with the words "compile 1004"
    Are there other "Key Words"?

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

    Re: Call in the Cavalry - 2015

    Hi Vlady,

    I just put such a thread in the Water Cooler - what gives??

  169. #169
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Call in the Cavalry - 2015


  170. #170
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2015

    Hi Vlady

    I have no issue when I click on this Link...what am I missing?

    http://www.excelforum.com/development-testing-forum/

  171. #171
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Call in the Cavalry - 2015

    Opps Sorry. Cleaned up the experiment thread titles.
    Still the key word affects and gives a database error message.
    compile 1004

  172. #172
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2015

    Hi Vlady

    Don't understand...what's the link?