Forgot to say:
You need to select at least one column with at least 5 rows, excluding the
title row (which also needs to be selected)
On Thursday, January 10, 2013 12:57:01 PM UTC+1, Adrian Teodorescu wrote:
>
> This is a rudimentary (and not thoroughly checked) graphical
> represen
This is a rudimentary (and not thoroughly checked) graphical representation
of data as a boxplot. It does not check the outliers using Grubb's test
however shows outliers that are farther than 1.5 IQR.
Looking for ideas on improving it.
Copy and paste the code into a new module and run the macr
This is a rather rudimentary conversion of Roman numerals into Arabic
(inverse of ROMAN function in Excel 2010)
Just copy the code and paste it into a new module. then in excel cell, type
= Arabic("xxx") where xxx is the Roman numeral (e.g. MMDX)
--
Join official Facebook page of this forum @
Instead of trying to fix this problem, could anyone tell me how I
could make multiple images execute the same code but with a different
parameter upon clicking?
--~--~-~--~~~---~--~~
--
Hello all,
I was wondering if anyone could tell me why, when I Duplicate a Shape
(image), I can't assign OnAction property to it. Following is a simple
code that gives me "Run-time error 1004: Application-defined or object-
defined error":
Sub Image1_Click()
Dim new_shape As Excel.Shape
on
>
> and then in any cell type =WhatsMyRow(A1) the cell will show 1
>
> On Jul 17, 5:22 pm, Adrian wrote:
>
>
>
> > Is there a way to create a custom function that will print out row
> > number that the function is in?
>
> > For example, in cell C5, I'
Is there a way to create a custom function that will print out row
number that the function is in?
For example, in cell C5, I'll type '=whats_my_row_number()' and I
would like it to say 5.
Thank you in advance,
--~--~-~--~~~---~--~~
--