• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Assigning named workbook ranges to VBA variable (Excel 2007)

    Thanks all - I appreciate your assistance :) Regards, Michael
  2. M

    Assigning named workbook ranges to VBA variable (Excel 2007)

    Hi SirJB7: Yep, that will work for assigning values from the worksheet. And then it is a short step to obtaining the address. So that's cool too. Thank you. Regards, Michael.
  3. M

    Assigning named workbook ranges to VBA variable (Excel 2007)

    Hi: I have changed the variables to string and that seems to work fine - strange because all the variables worked fine except for one. Anyway, I am not sure if this is really a fix, but it works. Regards, Michael.
  4. M

    Assigning named workbook ranges to VBA variable (Excel 2007)

    Hi there: Thank you for your advise. It seems that that option is not supported in my version of Excel - 2007. I am also contemplating another way to do this as well. Regards, Michael
  5. M

    Assigning named workbook ranges to VBA variable (Excel 2007)

    Hi: I am having some trouble with assigning named workbook ranges to variables in VBA. I have done the following: 1. Declared the VBA variables as Range variables 2. Used the Set function to load the variable content Example: Declare variable type Dim rng_Lastdate, rng_HistMax...
Back
Top