Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

June 2011 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • TRANSPOSE Changes Array Dimension

    Here’s an odd one, I think. I have code that creates a two-dimensional array and I want to use Application.WorksheetFunction.Transpose to switch the rows and columns. Sub TestTrans()         Dim aTest(0 To 3, 0 To 1) As Long     Dim vaTrans As Variant     Dim i As Long, j As Long       [...] Read More...
    Filed under:

  • Enable or Disable custom Ribbon buttons in Excel 2007-2010

    Hi all FYI, I add this page last weekend to my site : Enable or Disable custom Ribbon buttons in Excel 2007-2010 http://www.rondebruin.nl/enable.htm I also have a page for hiding and displaying : Hide or Display Custom Ribbon Tab/Group/Control with getVisible http://www.rondebruin.nl/hidevisible.htm If you have suggestions or good or bad comments let me know(I am no expert) Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...
    Filed under:

  • ByVal or ByRef Parameters

    Procedure arguments, either for a subroutine or a function, are declared either as ByVal or ByRef. The use of ByVal means that the called procedure does not want to change the value of the argument passed to it whereas the use of ByRef means that the called procedure may change the value. This note looks [...] Read More...
    Filed under: , ,
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.