Selecting an Excel Range in VBA

WallisMcMath  by "not work" what do you mean?  do you get an error?  the wrong location is selected? something else?  

Also, maybe you could/should attach your workbook or paste your actual code (maybe redacting parts if needed) but little things like curved vs straight quotation marks are common problems that we wouldn't know if you retype or transcribe your code here.

WallisMcMath 

If you just want to select B2:L34 in the Groups sheet as you describe, the following code lines will work.

DateR = 2
NameC = 2
LastNameR = 34
GFriIndexC = 12

Sheets("Groups").Range(Cells(DateR, NameC), Cells(LastNameR, GFriIndexC)).Select

 What you want to do with it, once selected (copy, clear, delete, change format etc.), is another issue. 

This code will not work as this is not a best practice to use .select

May I know what you want to achieve.

IF you want to copy the range from another sheet. you can do it with this code.

Sheets("Groups").Range("A2:A5").copy Sheets("Weekly").Range("A1")

A1 is a destination where you want to paste

Now if you want to use your integers. you can do it like this:

Sheets("Groups").Range("A" & DateR & ":" & "A" & Date R).copy Sheets("Weekly").Range("A1")

Application.cutcopymode =false

Considering DateR is a row

Else you can use very simple trick:

Sheets("Weekly").Range("A1").value = Sheets("Group").Range("A2").value

Or else

Sheets("Weekly").Range("A" & DateR).value = Sheets("Group").Range("A" & DateR).value

you can modify your code accoridngly. Right part is destination and Left part from where you want to copy the value

You should write VBA code what you want to achieve without selecting the range