Search results for query: *

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

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

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

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, I have just wrote my first piece of VBA code and while it works the MsgBox appears twice. It pops up, you hit OK, it pops up again you hit OK again. What wrong? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean) Call SaveWorkbook a =...