Macro to Convert Selected Range to Table

Hey guys!

I think I'm close... A simple macro to convert the selected cells to a table. Here's my code:

Please Login or Register  to view this content.

I'm getting Run-time error '1004':
Method 'Range' of object'_Global' failed

Cheers,
Lucas

Solved it myself. Needed to change Range(myRange) to just myRange. Also added an unlist to convert the table back to a range.

Please Login or Register  to view this content.