+ Reply to Thread
Results 1 to 3 of 3

Array for borders

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Array for borders

    I want to store the border details for a range in an array. This is for every cell in the range.
    It's hard to understand what the declaration type should be.
    This includes the properties:
    .LineStyle
    .Color
    .Weight


    This is so the borders can be reinstated at a later time.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Array for borders

    .Linestyle and .Weight are Long
    .Color is Double

    You could use a Variant for each and not worry about it.

    Alternatively, you could copy the range's formatting to another range, possibly on another sheet, and use that as the storage.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Array for borders

    Great, thanks for clarifying.
    It's becoming apparent that using a Variant for each is the way to go.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting row borders, eliminate Inside Borders within row
    By lizziemac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2018, 11:06 PM
  2. Replies: 5
    Last Post: 02-22-2018, 01:47 AM
  3. Replies: 2
    Last Post: 06-27-2017, 12:55 AM
  4. [SOLVED] Auto change borders to thick borders
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-22-2013, 11:17 PM
  5. [SOLVED] Quick Array question - Copy array to another array then resize?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-02-2013, 01:17 AM
  6. Replies: 3
    Last Post: 02-20-2012, 05:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1