Closed Thread
Results 1 to 1 of 1

Select visible cells within a set range

  1. #1
    Forum Contributor
    Join Date
    06-13-2009
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    245

    Smile Select visible cells within a set range

    Hello, could some one please help me with the following?

    I have been trying to use VBA to select the visible cells of my Excel 2003 worksheet named: 1 Mth. (it contains dummy-data).

    In the attached workbook there are some hidden cells at AA59000:AJ59200

    What I need:

    I need please to use VBA to select the visible cells in the range (A3: U10000), (not the hidden cells). Once I can select the visible cells, then I can format the visible data (not the hidden data).

    If any one could please help, it would be greatly appreciated.

    Kind regards,

    Chris
    Last edited by longbow007; 06-09-2010 at 09:21 PM.

Closed Thread

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