+ Reply to Thread
Results 1 to 3 of 3

Cell w/link formula to show as empty for VBA check before saving

  1. #1
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Cell w/link formula to show as empty for VBA check before saving

    Trying to describe my problem in the title is difficult. Here is the explanation. Cell A1 on sheetA is linked to a cell on sheetb(A1). My macro checks certain cells before closing if empty, if so a message appears. How do I check this cell if empty when it has the "=sheetB(A1) link? Probably a simple answer, but after an hour of searching on the internet I could not find the answer. Thanks.

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Cell w/link formula to show as empty for VBA check before saving

    If I'm understanding your question correctly, your asking how to check if a cell is blank if it's linked to the value another cell via a formula?

    If true, why not just check the value of sheetB(A1) instead of the cell with the =sheetB(A1) link in it?

  3. #3
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Cell w/link formula to show as empty for VBA check before saving

    Reason I can't check the cell on sheet b is the name of the sheet changes with each type of test, but the print macro is the same. Thus I do not have enough VBA knowledge to check a cell on a sheet that the name changes.

    I figured out my problem, that particular cell had a formula in it, thus was not producing "0" when kinked cell was empty! I changed it to just a link, now I can check if the cell "=0" for missing info in the cell on sheet b. Have to add a few lines to the macro to input a formula in certain cells so my print macro works right. Which I am sure there is a better way to doing that! I am new to this and basically making macro's from examples on the internet and asking the odd tougher problem here on this forum and almost always, get an answer, which is awesome!

+ 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] Looping through cell ranges in multiple worksheets and prevent saving if cell value empty
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-22-2013, 11:24 AM
  2. Replies: 4
    Last Post: 08-29-2012, 02:45 PM
  3. check a cell is empty or not
    By associates in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2006, 05:43 PM
  4. How do I check for an empty cell in a formula?
    By sasquatchbill in forum Excel General
    Replies: 4
    Last Post: 08-08-2006, 10:55 AM
  5. VB - Empty Cell Check
    By Fraggs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2005, 11:26 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