I'm trying to copy certain cells from one sheet to another. If the first cell is empty, I want the second cell to be empty, too, or, ideally, just have a space in it. Right now, I get "0". I tried an "IF" statement, but I can't seem to make it happy. Now I'm getting Err:511 or #NAME?.
This is for a template where the first sheet may have 2 or more rows. I don't want to have to go into the second sheet and delete all the extra rows that won't have anything in them every time I use the template. Also, if there are hyperlinks in the cell in the first sheet, only the link text appears in the cell in the second sheet -- not the hyperlink that's supposed to go with it. Is there anything that can be done about that? Thanks --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
