I've asked for help, but off the bat, this line is not correct

With EF
Do you mean:

With Worksheets("EF")
If so, then you need to add a dot before the Range so that it's .Range

abousetta