Problem with absolute references

[Clueless]

Absolute references made in code are not treated the same way as absolute references made in a basic Excel formulas, and I need to work around this issue. I have tried to get around it by setting the cells as a range, but I am having trouble manipulating the range.

I am trying to delete the values within the range, and here is my code:

Dim Rng As Range
Set Rng = "CM_Def_Vol"
Rng.Select
Selection.Value = 0

Dim Rng2 As Range
Set Rng2 = "CM_Def_Rev"
Rng2.Select
Selection.Value = 0

I am getting a type mismatch error.

Anybody know how to fix this?

Thanks! :)

[Killer42]

Dim Rng As Range
  Set Rng = "CM_Def_Vol"
  Rng.Select
  Selection.Value = 0
Dim Rng2 As Range
  Set Rng2 = "CM_Def_Rev"
  Rng2.Select
  Selection.Value = 0

I am getting a type mismatch error.

On which line?