Cleaning up code/avoid selecting

[sportsranker]

Hello Everyone,

Could someone help me clean up the code below? I am selecting cells, and I think that could be avoided.

What this does is inserts a hyperlink in N46 that points to another worksheet in the same workbook. Then it copies the formatting from the cell above.

Please Login or Register  to view this content.

I have started the cleanup, but I am not sure how to deal with the hyperlink statement and the formatting statment.

Thanks for your help.

[fecurtis]

Try:

Please Login or Register  to view this content.

As far as I know, with hyperlinks, you always have to have Excel select a cell otherwise it'll place a hyperlink in which cell is the ActiveCell.

[sportsranker]

Thank you! I think you are right about hyperlinks.