Search:

Type: Posts; User: jarhtmd

Search: Search took 0.01 seconds.

  1. How to Get & Use Worksheet Name in Excel2007 Macro

    Sorry, I didn't explain the situation clearly enough. Plus I made a posting error. The code that I posted was recorded while working in "2018" worksheet. I right-clicked the worksheet name tab at...
  2. How to Get & Use Worksheet Name in Excel2007 Macro

    I have an Excel2007 workbook with several worksheets. Most of the sheets are named with the 4-digit year (2017, 2018, etc).
    I recorded a macro to copy a worksheet and then do various things in the...
  3. Thanks, Alan. I was looking right past it. As my...

    Thanks, Alan. I was looking right past it. As my Mom used to say, "If it had been a snake it would have bitten me". Thanks also for explaining code tags.

    Using the (newly found) Excel options, I...
  4. How to turn Automatic Completion on/off in Excel 2007

    My worksheets don't auto complete as I type text into cells. I have not (knowingly) turned that off. It seems to be the same for all workbooks.

    Googling yields . . . "Click the Microsoft Office...
  5. Replies
    2
    Views
    1,121

    Thanks for your reply. However, I need to move...

    Thanks for your reply. However, I need to move the cursor to that cell for data entry. I should have stated that.

    I've discovered how to do just what I want (& more).

    To move to the last cell...
  6. Replies
    2
    Views
    1,121

    Jump to Last Used Cell in a Column?

    How do I jump to the last populated cell in a column?
  7. Replies
    2
    Views
    1,140

    I don't understand this "answer" at all. I...

    I don't understand this "answer" at all.

    I need to know specifically what each of the possibilities are so that I will know that I have provided (outside of Excel) for every possibility.
  8. Replies
    2
    Views
    1,140

    All possible on/off combos of 4 variables

    I have 4 variables "L S K B", any or all of which may either be "on" or "off". I need to get all possible on/off combinations . . . "- S K B", "L - K B", "L - - B", "L - - -", etc.

    Is there a...
  9. Sorry, I've been away & haven't been able check &...

    Sorry, I've been away & haven't been able check & use this. Thanks a million. It will be very useful.
  10. Thanks. That does exactly what I ask for. But ....

    Thanks. That does exactly what I ask for. But . . . I asked for the wrong thing.

    I apologize for not stating the situation more clearly.

    This workbook contains worksheets for various...
  11. How to name Excel worksheet based on min-max in column

    I have a workbook with several worksheets. Col C (in all sheets) contains various dates (mm-dd-yyyy). I would like to name the various worksheets using the last 2 digits in the year portion of the...
Results 1 to 11 of 11