Search:

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

Page 1 of 15 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    123

    Bingo. Sorry about that. I just copied my example...

    Bingo. Sorry about that. I just copied my example from the first post.

    I am good to go ... although I'm always interested in reading alternative solutions.
  2. Replies
    4
    Views
    123

    I think the first one suits my purposes best. ...

    I think the first one suits my purposes best.

    It's not quite working though.

    Following the examples in my first post, I created a Word document containing:

    €™ '
    €œ “

    Here's the first...
  3. Replies
    4
    Views
    123

    Word: Batch Find and Replace

    I'm using Word 2013 on Windows 8.1.

    Is there a way to set up something like a hash of items I'd like to find and replace that I could use on multiple documents?

    For example, I am scraping data...
  4. Replies
    8
    Views
    208

    Thanks MartinM: this workaround will do what I...

    Thanks MartinM: this workaround will do what I need.

    But I'm intrigued by Rory's suggestion. This definitely works for 2 digits. But I'm not sure how to get it to work for 3 digits. For example,...
  5. Replies
    8
    Views
    208

    Thanks Rory: yes, I use a fixed-width font in...

    Thanks Rory: yes, I use a fixed-width font in Excel. So is there a placeholder that will work?

    MartinM: Yes, of course I could left-align the cells ... but the whole reason for asking the question...
  6. Replies
    8
    Views
    208

    Sorry ... that looked good in the composition...

    Sorry ... that looked good in the composition window, but not so good when posted.

    My columns will be centered.

    I want the digits to line up like this:

    3a
    4

    But what I get is the 4...
  7. Replies
    8
    Views
    208

    Custom Format Placeholder

    I'm using Excel 2013 on Windows 8.1.

    I'd like a placeholder that will show a blank to the left of the decimal, but to the right of the digits.

    What I want is to be able to line up 3a and 4 over...
  8. Replies
    23
    Views
    939

    I haven't forgotten about this ... just swamped...

    I haven't forgotten about this ... just swamped with a different project.
  9. Replies
    23
    Views
    939

    Oh gosh ... I missed a big problem. This...

    Oh gosh ... I missed a big problem.

    This spreadsheet is used for grades. It gets wider through the semester. The named ranges I have pre-defined expand as I add grades to their interiors, always...
  10. Replies
    23
    Views
    939

    This is a big help, and I'm learning a lot. ...

    This is a big help, and I'm learning a lot.

    Here are some of the issue I've come up with.

    1) The code fails badly if there's a blank cell in the middle of column B. The general plan is to have...
  11. Replies
    23
    Views
    939

    1) The current exportHTML macro exports 2 named...

    1) The current exportHTML macro exports 2 named ranges from each sheet as individual HTML files, so 6 worksheets in my workbook yields 12 files on my desktop.

    2) Your SortPart macro runs, but I'm...
  12. Replies
    23
    Views
    939

    Fair enough. But I don't know how to do that....

    Fair enough. But I don't know how to do that. Thus the thread.
  13. Replies
    23
    Views
    939

    Reply to Maudibe: This isn't quite right. I don't...

    Reply to Maudibe: This isn't quite right. I don't want to permanently delete the information in those cells. All I want to do is export an HTML file in which those values are blanked.

    Reply to...
  14. Replies
    23
    Views
    939

    Try this. It's an xlsm based on the xlmt.

    Try this. It's an xlsm based on the xlmt.
  15. Replies
    23
    Views
    939

    I've attached another file. It's an xltm from...

    I've attached another file. It's an xltm from Excel 2013.
  16. Replies
    23
    Views
    939

    I only included a stub spreadsheet because the...

    I only included a stub spreadsheet because the real one is large. I figure the solution I need doesn't need all that detail.

    I am not wedded to this suggestion, but I think this is what I would do...
  17. Replies
    23
    Views
    939

    Modifying a macro

    I have two Excel macros that I often run consecutively. I need to filter the results in the second one.

    The first does a sort over a named range:


    Application.Goto Reference:="Sort_Block_1"
    ...
  18. Replies
    5
    Views
    179

    Thanks a bunch. I'm actually parsing through...

    Thanks a bunch.

    I'm actually parsing through a matrix that's written out as a vector. And I can replace the count() with a large integer, since what I'm counting up has to all fall within a...
  19. Replies
    5
    Views
    179

    Need confirmation ... I believe I have solved...

    Need confirmation ...

    I believe I have solved this problem by changing the count(A:A) bit to count(A2:A$786434) for an entry in row 2.

    Am I missing anything that anyone can see?
  20. Replies
    5
    Views
    179

    Promising (seems OK at the top). But ... it...

    Promising (seems OK at the top). But ... it returned a #REF! from row 262,600 downward.

    I think I know where the problem is, but I'm not sure how to address it.

    Because there are 786,435 rows...
  21. Replies
    5
    Views
    179

    Conditionally Void a Cumulative Sum

    I have a large data set (800K rows), so I'm looking for 1) any solution to my problem, but 2) an efficient one would be better.

    See the attached file ...

    I have columns A and B filled with...
  22. There's a lot to go with here, some of which...

    There's a lot to go with here, some of which works.

    1.


    This works well. There are two problems (worked around here for people who have this problem in the future).

    1) Using row() inside...
  23. Collapse range's entries by removing some values

    Suppose A1.A9 looks like this:

    1,2,=na(),4,=na(),6,7,8,9

    I am looking for a way, ideally with (plain) formulas in B1.B7 to get:

    1,2,4,6,7,8,9

    If I were coding this, it would be easy to...
  24. Replies
    0
    Views
    204

    Format/Strategies for HTML Output

    I output from a spreadsheet to HTML. I format my cells with a custom format (like ?0.0) so that the "ones digits" and "tens digtis" line up when I center the column. When Excel outputs this to HTML,...
  25. Replies
    4
    Views
    506

    Thanks. Yes, this seems to do what I need. Not...

    Thanks. Yes, this seems to do what I need. Not very convenient for sharing though ...
Results 1 to 25 of 355
Page 1 of 15 1 2 3 4