Recent content by jnowles

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

Thank! I think I got it.

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

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...

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

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...

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

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

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...

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...

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

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...

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

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...

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.