Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    7
    Views
    930

    Re: Application.Run in userform

    How about making the sub in the user form a one line call to a sub in a module and have application.run run the sub in the module?
  2. Replies
    9
    Views
    3,013

    Re: Format cells based on legend

    Yeah, if people need to make edits to cells with conditional formatting, than doing things like cut and past can really scramble your formatting regions up.

    Here's a good reference for using...
  3. Replies
    4
    Views
    171

    Re: Counting problem

    You can just remove the quote marks from around your range names. Or any of these other ways would work:

    'D4
    or
    ="D4"
    but not
    "D4"
  4. Replies
    5
    Views
    9,531

    Re: rename ranges, using VBA

    Sorry for the sick bump but I didn't find any alternative solutions posted anywhere so I thought I'd update this.

    Using 2010, I used Andrew Poulsom's two partial solutions and just pieced them...
  5. Replies
    35
    Views
    60,883

    Re: vbNullString

    Not the answer I was expecting because my second guess would have been a 0 not "" based on this blog, which I found after posting here.

    Not that it's important because neither case provides a...
  6. Replies
    35
    Views
    60,883

    Re: vbNullString

    Thanks for the prompt reply.

    So are you saying that the existence of a formula within a cell precludes it from being null or that there's currently no method to provide a null value?

    So...
  7. Replies
    35
    Views
    60,883

    Re: vbNullString

    I recall running across a thread where a null value in an excel cell is treated differently than "" and there were functions where a null value was ok while "" would produce errors. The issue was...
  8. Re: Font for form control changes size on focus

    Limited experience with this so I hate to speculate but there doesn't seem to be many replies to this bug that I've seen so I thought I'd throw this out there. Just be aware that I haven't had the...
Results 1 to 8 of 8