Error: Method 'Range' of object '_Global' failed

Hi,
Sorry to be asking such an easy question- struggling to understand why this is displaying an error (the Method 'Range' of object '_Global' failed error)

Please Login or Register  to view this content.

I've tried to dim "myrng" as variant, as object... all I want to be able to do is to select a range that I've pre-defined. I know I could just do Range("b1:b10"), but want to understand why this alternative method doesn't work.

Thanks!