Rank: 2553 based on 53 downloads (last 30 days) and 2 files submitted
photo

Richard de Garis

E-mail

Personal Profile:
Professional Interests:
hedge fund risk management

 

Watch this Author's files

 

Files Posted by Richard View all
Updated   File Tags Downloads
(last 30 days)
Comments Rating
17 Sep 2013 Calculate Excel Range Calculates full target range in Excel A1 notation. Author: Richard de Garis excel, range, named range 26 4
  • 5.0
5.0 | 3 ratings
01 May 2009 Screenshot pie2 Modification of the Matlab PIE function to account for label overlaps Author: Richard de Garis pie, label, pie label, graphics, modification, customization 27 3
  • 5.0
5.0 | 3 ratings
Comments and Ratings by Richard
Updated File Comments Rating
16 Sep 2013 Calculate Excel Range Calculates full target range in Excel A1 notation. Author: Richard de Garis

Hi Traian,

You need to provide a reference cell, or range of cells, or named range e.g. A1, or A1:D3, or myStartCell

If using an explicit A1-notation range, you can prepend with the workbook and or worksheet (as in my example in the function Description). However, an Excel named range must be specified on its own.

I have just submitted an update that allows you to specify, if using an Excel named range, a particular workbook via a COM object handle, which allows for Excel named ranges in a multi-workbook environment. But the COM handle is ignored if just using an explicit A1-notation range, since that is workbook agnostic.

Comments and Ratings on Richard's Files View all
Updated File Comment by Comments Rating
01 Dec 2013 Calculate Excel Range Calculates full target range in Excel A1 notation. Author: Richard de Garis Joseph, Rajesh

Worked well for me. Thanks.

16 Sep 2013 Calculate Excel Range Calculates full target range in Excel A1 notation. Author: Richard de Garis de Garis, Richard

Hi Traian,

You need to provide a reference cell, or range of cells, or named range e.g. A1, or A1:D3, or myStartCell

If using an explicit A1-notation range, you can prepend with the workbook and or worksheet (as in my example in the function Description). However, an Excel named range must be specified on its own.

I have just submitted an update that allows you to specify, if using an Excel named range, a particular workbook via a COM object handle, which allows for Excel named ranges in a multi-workbook environment. But the COM handle is ignored if just using an explicit A1-notation range, since that is workbook agnostic.

09 Sep 2013 Calculate Excel Range Calculates full target range in Excel A1 notation. Author: Richard de Garis Preda, Traian

Hi,

I have a question, can I use this function only by typing xlcalcrange('c:\mytestfile.xls') or I have to provide the selection from excel?

Can you please send me an example regarding how I can use this function for an excel file.

Thanks

02 Aug 2013 Calculate Excel Range Calculates full target range in Excel A1 notation. Author: Richard de Garis Arjun

Works like a charm! Thanks!!

14 Mar 2012 pie2 Modification of the Matlab PIE function to account for label overlaps Author: Richard de Garis Prabhakar

excellent tool.

Contact us