+ Reply to Thread
Results 1 to 5 of 5

Correct syntax for Activecell.EntireRow.Range

  1. #1
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Correct syntax for Activecell.EntireRow.Range

    Can I please get some help for the correct syntax in this code:

    I want the macro to run only if the selected Row is empty between column ("B") and Colunm("N")

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,410

    Re: Correct syntax for Activecell.EntireRow.Range

    Maybe this way...
    Please Login or Register  to view this content.

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Correct syntax for Activecell.EntireRow.Range

    It's not clear exactly what you are trying to do...

    But something like below, assuming you want to run the code on worksheet change event...

    Please Login or Register  to view this content.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  4. #4
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: Correct syntax for Activecell.EntireRow.Range

    Thanks Rick

    I did get your solution to work, but thanks for you effort. :-)

  5. #5
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: Correct syntax for Activecell.EntireRow.Range

    Thanks CK76

    This is perfect :-)

+ 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. [SOLVED] Move ActiveCell.EntireRow to another sheet
    By chriskay in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-01-2019, 08:12 AM
  2. [SOLVED] activecell.entirerow.select end at column 14?
    By fight2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2015, 10:21 AM
  3. Correct syntax for using variable in range selection
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2012, 11:52 AM
  4. Getting the correct Syntax for Range in Sorting
    By highlystrung in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2011, 04:50 PM
  5. ActiveCell.EntireRow Problem
    By Slyone2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-09-2010, 11:48 PM
  6. activecell.Formula range refernce syntax issue
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2009, 03:30 PM
  7. If ActiveCell.Font.Bold = True Then ... trying to specify a range, not 'entirerow'
    By Winawer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2006, 06:08 PM

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