Results 1 to 3 of 3

Thread: Checking if range of cells=VbNullstring

  1. 02-02-2012, 06:29 AM #1
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Checking if range of cells=VbNullstring

    I am looking for VBA code - to search a Range of cells - I want to make sure all cells in the specified Range are empty - any suggestions
    xl2007 - Windows 7
    xl hates the 255 number
    Reply With Quote Reply With Quote
  2. 02-03-2012, 06:14 AM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    something like

    Code:
    msgbox selection.cells.count=worksheetfunction.counta(selection)
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  3. 02-03-2012, 07:24 AM #3
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    Ahhh - never used .Counta - cool Thanks
    xl2007 - Windows 7
    xl hates the 255 number
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Delete All Empty Cells From Range Using VBA / Remove Blank Cells Using Formula
    By mahmoud-lee in forum Excel Help
    Replies: 13
    Last Post: 06-10-2013, 09:05 AM
  2. VBA Looping Input Range and Output Range
    By Whitley in forum Excel Help
    Replies: 7
    Last Post: 04-25-2013, 09:02 PM
  3. Remove Entire Row of Blank Cells in Column, Autofilter non-empty non-blank cells
    By sanmaya in forum Excel Help
    Replies: 2
    Last Post: 09-24-2012, 11:19 PM
  4. List selected filenames in an Excel range of cells
    By TomyLee in forum Excel Help
    Replies: 2
    Last Post: 09-24-2012, 06:24 PM
  5. Checking Table Exist in Access Database or Not
    By littleiitin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 11-16-2011, 04:32 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
  •  

Forum Rules