range resize

  1. P

    Reduce size of Range - Syntax question

    I hope this is a trivial question! Given a Worksheet variable - WS, and a Single Column Range on that Worksheet - V (eg G1:G260), and an Index -- i where i is the index of the first row of interest in that range (eg 12), What is the VB or VBA syntax for setting V to be the Range starting with...
  2. P

    Reduce size of Range - Syntax question

    I hope this is a trivial question! Given a Worksheet variable - WS, and a Single Column Range on that Worksheet - V (eg G1:G260), and an Index -- i where i is the index of the first row of interest in that range (eg 12), What is the VB or VBA syntax for setting V to be the Range starting with...
  3. W

    Exclude range objects from range

    All, I have a tough one for you. Does anyone know if there is a way to create a range object that contains a known range, excluding other overlapping range objects. For example, let's say I have a pivottable called pvTable1 (dim pvTable1, set pvTable1 = ...). What I would like to do is...
  4. N

    resize a named range

    I have a range "A1" named array.Now I want to resize this "array" to include two more rows and keeping only one column.How to do that in VBA.

Some videos you may like

This Week's Hot Topics

Top