Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Hi all,


    I have a worksheet with columns and rows hidden- makes the sheet look cleaner

    With a set range object, when writing or reading from a cell, do the hidden cols and rows make a difference, so that if I'm putting data in cells(1,10) and I hide the (2,9) when I write data to the hidden cells will it make it there? or will it be in cells(1,20) when the sheet has no hidden cells?

    Just looking for an opinion,

    Thanks in advance,
    Darryl

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Expressions such as Cells(5, 4) and Range("D5") do not depend on the visibility of rows and/or columns - they always refer to the same physical cell.

Posting Permissions

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