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

    Is there a way to easily generate a series of named ranges

    I am looking for a way to easily generate a series of names for some dynamic ranges. For instance I want to define these dynamic ranges for later use in charts: KPI_1 = OFFSET(KPI,1,3,1,MTH) KPI_2 = OFFSET(KPI,2,3,1,MTH) KPI_3 = OFFSET(KPI,3,3,1,MTH) KPI_4 = OFFSET(KPI,4,3,1,MTH) KPI_5 =...
  2. U

    How do I find pixel size of a range

    Is there an easy way of obtaining information on the pixel size of a range (say width and height of the area A1:B2 or a defined print area)? Can it be done by means of a formula or does one need to resort to VBA?
Back
Top