Results 1 to 2 of 2

question about range properties

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2012
    Location
    Ma
    MS-Off Ver
    Excel 2007
    Posts
    1

    question about range properties

    please don't kill me if this is indeed a terribly ignorant idea but...

    I wanted to try passing range properties like value,formular1c1 and style from an array(which is being held in a variant.

    This is an example similar to what I am trying to do:

    Sub goodtimes()
    
    Properties_array(value,value,style,formular1c1)
    y = array(1,3,7,8)
    output = array(stuff,things,"percent","=RC[-1]/RC[-2]")
    
    for i = 0 to ubound(y)
    Cells(y(i),1).properties_array(i) = output(i)
    next i
    
    end sub
    Is it possible?
    Last edited by JiffyJ; 11-02-2012 at 06:13 PM.

Thread Information

Users Browsing this Thread

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

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