linked cells show "0"

  • Thread starter Thread starter Lenny
  • Start date Start date
L

Lenny

I set up links within a number of cells from worksheet 1 to various cells in
worksheet 2. The cells, on worksheet 2, instead of being blank are showing
"0". Is there a way to eliminate the 0 so the cell is blank also?

Regards - Lenny
 
=if(sheet2!a1="","",sheet2!a1)

Just check first.
I set up links within a number of cells from worksheet 1 to various cells in
worksheet 2. The cells, on worksheet 2, instead of being blank are showing
"0". Is there a way to eliminate the 0 so the cell is blank also?

Regards - Lenny
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Copying linked sheet 2
3d reference 5
Ignore Blanks 2
Blank Cell Reference, without if statement 4
Linking blank cells 1
"0" in pasted link 1
Links 4

Back
Top