Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Excel related, but not formulas or visual basic

    Thanks, Dr.

    What I'm doing is opening an Excel file, and all is well. I open another one (or two), and eventually, toggling back and forth between them, one will go into hiding.
    I can always...
  2. Excel related, but not formulas or visual basic

    Hello...

    My work computer was recently upgraded and Excel now is hiding workbooks that I have open.
    I'm not hiding them, but until I found out about how to find hidden files, thought I was losing...
  3. Replies
    3
    Views
    292

    Re: UserForm displays value of a cell

    Hello, Jim...

    That worked well. But I have one more question:

    I got it to work with just the line: TextBox1.Text = Range("E3").Value

    Is there a reason for the first line which by...
  4. Replies
    3
    Views
    292

    UserForm displays value of a cell

    Greetings, all...

    I have a user form which needs to inform the user how many missing documents he needs to complete.

    Cell E3 has the tally of the number of missing documents.

    I have tried...
  5. Replies
    7
    Views
    386

    Re: Go to Sheet named in cell

    Meldoc,

    Okay, I got it...

    Sub Locate_Sheet()
    With Sheet1
    Sh = .Range("E2")
    Sheets(Sh).Select
    End With
    End Sub
  6. Replies
    7
    Views
    386

    Re: Go to Sheet named in cell

    Hi, meldoc...

    I did as you suggested. In cell "E2" of Sheet1 , I typed "Sheet2". In cell "A1" of Sheet2, I typed "Hello". I posted your code in a module and ran it. Sheet2 remained the same....
  7. Replies
    7
    Views
    386

    Re: Go to Sheet named in cell

    I ran the code and the only thing that happened was that row 1 (which had been 13.5 in height) changed to 383.25.

    I thought "Well maybe 'Sheet1' needs to be the actual name of the sheet" (I get...
  8. Replies
    7
    Views
    386

    Go to Sheet named in cell

    Hello, all..

    I have a user input sheet which asks a user for a machine and a platform and then the number of documents for each part of the machine. Easy enough.

    Once the user has populated the...
  9. Re: Printing grade sheet (one for each student) from list

    Smitty,

    Thanks, so much. You got me on the right track. The difficulty was in getting it to stop printing when the names stopped. There can be up to 25 students per class. Their names are entered...
  10. Printing grade sheet (one for each student) from list

    Greetings, all...

    Column AA1 has a list of student's names (it varies each term). Cell B9 has been a drop down list which when one was selected, updated vie vlookup the student's scores in each...
  11. That's the route I've been using. I was looking...

    That's the route I've been using. I was looking for something a bit more elegant and simple. It also doesn't limit the filtering to a single character. ie.

    abs 2
    acs 2
    achs 2

    With this...
  12. Conditional format with wildcard in formula

    I am trying to write a conditional formating IF statement that requires the use of a wildcard (?)

    If the value of C1 is "abs 2" then true.
    If the value of C1 is "als 2" then true.
    If the value...
  13. Ralph, Thanks for the reply. In response to...

    Ralph,

    Thanks for the reply.

    In response to the long formula inquiries, the date in my workbook comes in formatted MM/DD/YYYY. When I originally tried the =RIGHT(J3,2) formula, it returned the...
  14. vlookup with concatenated multiple references

    I have a workbook which keeps track of all the reports I run on all our projects. Every two weeks, I run a report on the budget hours vs. the actual hours logged for each project. And I keep the date...
  15. Replies
    9
    Views
    2,084

    vlookup concatenated reference

    I have a workbook which keeps track of all the reports I run on all our projects. Every two weeks, I run a report on the budget hours vs. the actual hours logged for each project. And I keep the date...
  16. Replies
    3
    Views
    568

    Steve, Here's something that might work - if...

    Steve,

    Here's something that might work - if all rooms are the same size. You should be able to customize it as needed though.

    ******** ********************...
  17. Replies
    7
    Views
    14,244

    Eddie G, Welcome to the board. You wouldn't be...

    Eddie G,

    Welcome to the board. You wouldn't be interested in posting your code for deleting the other macros you mentioned, would you? I've been trying to come up with a macro-blaster that works,...
  18. Replies
    3
    Views
    360

    Can you post an example of what you have and what...

    Can you post an example of what you have and what you want? I (or some one else) might have a better idea of what you need...

    Jim
  19. Replies
    3
    Views
    360

    Welcome to the board! I use the following in...

    Welcome to the board!

    I use the following in one of my books. I have a column with this formula.

    =IF(C2="","",IF(ISNA(VLOOKUP(C2,'Part Code.xls'!PART_CODE,(3),0)),"Item Not...
  20. Replies
    6
    Views
    731

    Greetings. I'd use something like: ...

    Greetings.

    I'd use something like:

    =IF(ISERR(C28/C29),"ERROR",C28/C29)
    or
    =IF(ISERR(C28/C29),"",C28/C29)
    if you didn't want anything to show...

    HTH,
  21. Replies
    5
    Views
    331

    Re: Formula copy Macro Question

    How about this?

    Sub Copy_C15()

    ans = Sheets("Sheet1").Range("C15")
    ActiveCell = ans

    End Sub
  22. Replies
    8
    Views
    2,088

    Zack, Yes, the formula works fine. But to use...

    Zack,

    Yes, the formula works fine. But to use it, I have to configure it to a specific file. I couldn't "indirect()" it or "value()" it. What I wanted (and made a VBA solution for) was to...
  23. Replies
    8
    Views
    2,088

    Appearantly, doing this formula-magically is next...

    Appearantly, doing this formula-magically is next to impossible. But in VBA, the following topic may be of use to future searchers:

    http://www.mrexcel.com/board2/viewtopic.php?t=123811

    HTH,
    Jim
  24. Replies
    2
    Views
    792

    Glaswegian, That worked perfectly! Thanks so...

    Glaswegian,

    That worked perfectly! Thanks so much.

    Cheers,
    Jim
  25. Replies
    2
    Views
    792

    Code allows text entry, but not formula

    Greetings,

    I wrote a macro to add a formula to a cell, then copy the cell down
    In cell A1, I have the customer's name
    In cell A3, I have the sales order number

    Our purchasing department keeps...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4