Thread: How to set a range based on area selected using mouse?

I'm sure this is a simple one liner, but it escapes me (as do most things).

I'm trying to set a variable for a range based on the cells selected. For example, I want variable "myrange" to be set to range("A1:D14") if I click on cell A1 and drag it to D14.

So far everything I've tried ends up getting the good old "1004 - Application defined or object defined error"

Thanks!

Do you mean

Dim myRange As Range
Set myRange = Selection
'do stuff
Set myRange = Nothing

At least now you know it's Friday...