+ Reply to Thread
Results 1 to 8 of 8

Starting from the actual activecell, go to the next empty visible row

Hybrid View

  1. #1
    Registered User
    Join Date
    02-19-2018
    Location
    Czech Republic
    MS-Off Ver
    Excel 2016
    Posts
    68

    Re: Starting from the actual activecell, go to the next empty visible row

    Hi AlphaFrog!

    It worked perfectly! Thank you so much!

    Now I'm curious... how exactly works the part of "xlValues, , , 1)"? what is the meaning of each comma and the number?

    I'm asking because I have a keypad in this Excel, and when pressing the arrow "up" runs this code:

    ActiveCell.Offset(-1, 0).Select
    Do Until ActiveCell.EntireRow.Hidden = False
    ActiveCell.Offset(-1, 0).Select
    Loop

    So, is there a way to use the same code you sent me, but instead of going to the next down cell, going to the upper next cell?

  2. #2
    Registered User
    Join Date
    02-19-2018
    Location
    Czech Republic
    MS-Off Ver
    Excel 2016
    Posts
    68

    Re: Starting from the actual activecell, go to the next empty visible row

    OK, in order to go up, I just did it my way and it works :D

    On Error Resume Next
    ActiveCell.Offset(0, 0).Select
    ActiveCell.Offset(-1, 0).Select
    If ActiveCell.EntireRow.Hidden = True Then ActiveCell.End(xlUp).Select
    If ActiveCell.EntireRow.Hidden = False Then ActiveCell.Offset(0, 0).Select
    If ActiveCell.Row <= 5 Then ActiveCell.Offset(1, 0).Select
    Do Until ActiveCell.EntireRow.Hidden = False
    Loop
    Thanks you all!

+ 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. difference in between activecell.activate and activecell.select
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2020, 03:14 AM
  2. How to Calculate actual date when starting date and months is given?
    By ulala2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2015, 03:38 AM
  3. [SOLVED] Macro to scroll to activecell and make visible in middle of screen
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2015, 02:38 PM
  4. [SOLVED] Autofill text starting at the ActiveCell
    By canadian_chickie in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-10-2012, 03:55 PM
  5. export a calculation to excel so that the actual numbers and answer are visible
    By Sean Loughran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2012, 03:04 PM
  6. Output contents of Activecell when Activecell may be string or numeric.
    By jfriddle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 12:27 PM
  7. Paste Multiple listbox items starting at ActiveCell
    By Casey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2006, 02:45 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