Search:

Type: Posts; User: brucemc; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: If Chip Pearson's website ever helped you, please jot a note...

    I only now learned of Chip's passing. I would like his parents to know that not only did the resources he provided us all with help me numerous times, and will continue to help me, but he also took...
  2. Re: Excel range to HTML for Outlook message body

    For those that might run into the problem in the future I am posting the solution-

    The range I selected was roughly 12 columns wide. Text lines were posted into the first four (4) columns of this...
  3. Excel range to HTML for Outlook message body

    Good Day All!

    Mr. de Bruin has outstanding examples from which I have learned much. Unfortunately I have hit a roadblock in my attempts to convert a range to html and send it. For some unknown...
  4. Re: Populate userform combobox with unique values from a range

    I am blown away - this was the perfect answer for what I was looking for, and notably over my head-
  5. Replies
    0
    Views
    210

    Add in to identify unused variables

    A couple years ago I came across an excellent utility (free also...) that would go through my code and provide a report that included all the variables I created while I was stumbling along and ended...
  6. Worksheet ActiveX Combobox: Named Table as ListFillRange

    Hi folks, I'm back, which means once again I am relearning everything I forgot. THANK-YOU for still being here to help!

    I am working with an ActiveX Combobox on a Worksheet. On the same worksheet...
  7. Replies
    3
    Views
    605

    Re: VBA, Autofilter, multiple items

    Thank-you. It might have simply been an older article, I am on 2010. I think I found something that has me on a good path, but I am afraid of citing the page as I don't recall if doing so will...
  8. Replies
    3
    Views
    605

    VBA, Autofilter, multiple items

    In learning about using autofilter through vba, I believe I read that the maximum items I can stipulate are two.

    What I want to do is have a list of approx 15 students on a worksheet that would be...
  9. Replies
    3
    Views
    475

    Re: External workbook links

    I thought that if they were in the same directory I could omit the path, but perhaps not... In any event, the dang thing won't let me obliterate path names from the reference!
  10. Replies
    3
    Views
    475

    External workbook links

    Hi!

    I have a zillion references in a workbook to roughly five other workbooks, and they all take the form of:
    =+'U:\TLC\TLC\ARO\2010 Budget\PPHD\[Dept Bgt 2010 Sales.xls]Summary'!C17
    Lord nly...
  11. Replies
    15
    Views
    20,267

    Re: Excel 2010 VBA Left & Ltrim functions???

    Thank-you very much for your fast help!!! I greatly appreciate it.
  12. Replies
    15
    Views
    20,267

    Re: Excel 2010 VBA Left & Ltrim functions???

    I am unclear to what is asked by:
    What is the code that line is in actually doing?
    Oh. Upon re-reading it I find the confusion was from how my mind was paring your question (embarrassment).
    In...
  13. Replies
    15
    Views
    20,267

    Re: Excel 2010 VBA Left & Ltrim functions???

    I am unclear to what is asked by:
    What is the code that line is in actually doing?
    Oh. Upon re-reading it I find the confusion was from how my mind was paring your question (embarrassment).
    In...
  14. Replies
    15
    Views
    20,267

    Re: Excel 2010 VBA Left & Ltrim functions???

    I am afraid your last sentence is unclear to me - are you asking that I simply post some examples where the code is halting?

    Also, I just installed Calendar Control MSCAL.OCX as an addin, and...
  15. Replies
    15
    Views
    20,267

    Re: Excel 2010 VBA Left & Ltrim functions???

    Oh my. Have a look at:
    http://www.eggheadcafe.com/software/aspnet/31786052/microsoft-calendar-control-110.aspx

    I think this might give me some ideas. Seems to be a good lead, and looks like...
  16. Replies
    15
    Views
    20,267

    Re: Excel 2010 VBA Left & Ltrim functions???

    Located in the ThisWorkbook object. Change to ThisWorkbook worked.

    Seems all character handling functions need to be preceded with "VBA." -
    Left
    Right
    Mid
    Trim
    Ltrim
    Rtrim
  17. Replies
    15
    Views
    20,267

    Re: Excel 2010 VBA Left & Ltrim functions???

    Ohhhhh, this is really sick.

    going through the file emailed to me I don't get the "Refereces" window pop-up. under Tools: References is grayed out, so I am having to go through all the code and...
  18. Replies
    15
    Views
    20,267

    Re: Excel 2010 VBA Left & Ltrim functions???

    Thank-you!

    I suspect 90% of the trouble (or more) is that though at one time I was quite deep into VBA, it has been a while and I tend to forget what I am not actively using...

    For that first...
  19. Replies
    15
    Views
    20,267

    Re: Excel 2010 VBA Left & Ltrim functions???

    Strange (for me!). Though I did not find the items described in Tools:Options, in opening the sheet and running into the error the VBE does take me directly to a window titled "References <sheet...
  20. Replies
    15
    Views
    20,267

    Excel 2010 VBA Left & Ltrim functions???

    I posted this in the Windows 7 forums, but have not seen anything in 10 hours. Please forgive the double post, but I need to find out what the heck is happening-

    I just opened an Office 2007 Excel...
  21. Replies
    24
    Views
    1,622

    Re: What good is the 2007 ribbon?

    Now, now...

    Can't say that I know their work. What I can say is "If it walks like a duck, and talks like a duck, and looks like a duck..."
  22. Replies
    24
    Views
    1,622

    Re: What good is the 2007 ribbon?

    I believe that. It is what makes the questionable ones really stand out, especially when those few individuals have a blog or a newsletter...
  23. Replies
    24
    Views
    1,622

    Re: What good is the 2007 ribbon?

    Uhg. Time to eat a little crow (that is something us old folks from the country sometimes say).

    I went over to the MS Office 2007 training area and started on the lessons. Very nice, and I have a...
  24. Replies
    24
    Views
    1,622

    Re: What good is the 2007 ribbon?

    With that being firmly said, I guess my best response at this point is "OH GOODY! The ribbon has arrived!!!"

    Maybe a dedicated "User experience" study of the MVP community might be a good idea???
  25. Replies
    24
    Views
    1,622

    Re: What good is the 2007 ribbon?

    Ahhhhhhh. You mean with all those millions of scientific samplings that they took in order to no longer guess at what commands are used in order to design the new ribbon interface as referenced in...
Results 1 to 25 of 34
Page 1 of 2 1 2