+ Reply to Thread
Results 1 to 3 of 3

Apply cell numbering to visible rows only

  1. #1
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Apply cell numbering to visible rows only

    Hi everyone,

    I have the following code which applies number to all cells in in column A as long as there is data in column B:

    Please Login or Register  to view this content.
    What I'm trying to do is adjust the code so that it'll only run on VISIBLE rows. Any hidden rows, usually by filtering, should not have the numbers applied.

    Any ideas?

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: Apply cell numbering to visible rows only

    Solved.

    Please Login or Register  to view this content.

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Re: Apply cell numbering to visible rows only

    Probably just need to use special cells.

    Please Login or Register  to view this content.

+ 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. Speedup VBA and Apply to all visible sheets
    By Paul Cherian in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-08-2016, 02:14 AM
  2. Replies: 1
    Last Post: 06-09-2016, 12:12 PM
  3. [SOLVED] apply formula to only those rows that are visible after sort
    By mlski4751 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2016, 03:54 AM
  4. [SOLVED] how do you apply formatting to just visible cells?
    By ammartino44 in forum Excel General
    Replies: 4
    Last Post: 05-06-2014, 08:01 PM
  5. Use visible rows from autofilter to build Pivot table. Or use visible rows to Copy/Paste
    By mwhitedesigns in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 10:34 AM
  6. Apply formula only to visible cells
    By Fatboy10 in forum Excel General
    Replies: 2
    Last Post: 06-17-2012, 07:34 AM
  7. Sequential numbering for visible cells
    By skaura in forum Excel General
    Replies: 1
    Last Post: 07-21-2005, 08:05 AM

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