Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jnowles

  1. jnowles

    Is this possible with an external hard drive?

    Thanks for the recommendations. My computers stand alone so I'm researching units like the Lacie you mentioned. jean
  2. jnowles

    Is this possible with an external hard drive?

    Thank! I think I got it.
  3. jnowles

    Is this possible with an external hard drive?

    Thanks! Just to be sure I understand you correctly, if I install an application on an external hard drive I will then be able to run that application on any computer that I connect to that hard drive? Jean
  4. jnowles

    Is this possible with an external hard drive?

    Hello, I would like to purchase an external hard. My vision is that I can simply plug it into my USB port, load and execute software application from the drive thus relieving some of the confusion on my current hard drive. I want a portable model that I can use on both of my computers. This...
  5. jnowles

    Trying to return range from InputBox

    I copied and ran the following. It fails with Run-Time '424' error Sub MarkFactor6() Dim rRange As Range Dim numCols As Integer Set rRange = Application.InputBox("Select data range", _ "PRINT RANGE", , , , , , 8) numCols = rRange.Columns.Count MsgBox numCols End Sub
  6. jnowles

    Trying to return range from InputBox

    What I’m doing…….. - My datafile contains entries in the following format F1 F2 Fr3 F4 F5 note1 0.13 0.00 0.05 0.07 -0.05 note2 0.13 0.01 0.07 0.05 -0.10 note3 -0.02 0.22 0.12 -0.06 0.25 note4 0.02 0.04 -0.11 0.17 0.19 note5 0.03 0.23 0.01 -0.13 -0.10 note6...
  7. jnowles

    Trying to return range from InputBox

    For me, this still fails everytime for me. I'm so frustrated.
  8. jnowles

    Trying to return range from InputBox

    It is a VBA question, at "About" the VB editor says 'Microsoft Visual Basic'.
  9. jnowles

    Trying to return range from InputBox

    Hi, Thanks for your suggestions, The Sub always fail for me, I'm running VB version 6.3 The data I'm using is F1 F2 F3 note1 0.13 0.00 0.05 note2 0.13 0.01 0.07 note3 -0.02 0.22 0.12 note4 0.02 0.04 -0.11 note5 0.03 0.23 0.01 note6 -0.01 0.12 -0.02 note7 65.00 -0.08 0.06 note8 0.16 -0.05...
  10. jnowles

    Trying to return range from InputBox

    Hi, I'm trying to write a Sub to return a range that will be used later. I want to use an InPutBox to select the desired data then return the number of columns for later computations. An error '424' - object required, is returned regardless of how I define rRange. The error is at Set...
  11. jnowles

    Combining Index, Match, Max and Abs functions

    Ken, Thank you, excactly what I wanted in both cases. I'll need to look-up array formulas.
  12. jnowles

    Combining Index, Match, Max and Abs functions

    I’m stumped. I have a table like below and want to paste in col H (col7) the column heading of the maximum of the absolute values of col1-col6. For example at note1 col 7 returns “col1” while at note12 col7 returns “col2”. I would then like to shade the cell (b12:G12) containing that max abs...
  13. jnowles

    Nested Pivot Tables

    That's perfect. To push the envelope further, within r1,r2,r3,r4 can you calcutate col percent by sample and reading. For r1 and r2 the output would look like: r1 434 837 5 0 25 6 25 0 7 75 25 8 0 25 9 0 25 r2 434 837 5 0 25 6 50 0 7 25 25 8 25 25 9 0 25
  14. jnowles

    Nested Pivot Tables

    Can you nest pivot tables? I have a spreadsheet in the following foumat: ID SAMPLE r1 r2 r3 r4 1 434 6 7 7 6 1 837 5 5 6 6 2 434 7 6 4 4 2 837 7 7 8 8 3 434 7 8 8 8 3 837 9 9 9 8 4 434 7 6 8 7 4 837 8 8 7 6 and would like to transform it to look like: ID 434 837 r1 1 6 5 2...
  15. jnowles

    Help with BeforeSave

    Hi Melinx, That helped immensely, Thanks for helping me identify the problem. Your code worked perfectly when I removed the MsgBox statement, so I put the message in the SaveWorkBook routine.
See more

Part and Inventory Search

Back
Top