thanks graham but it's not outputting anything i took out the if statement and i got name not valid error. i'm looking for a workaround as i need the name to be the hyperlink values from excel. i posted in the other forum for help with greg if you want to see it and want to help me. sorry about double posting i just wasn't getting any answers >.<

http://www.vbaexpress.com/forum/show...620#post362620