I am trying to get excel to go from the activecell ("A1") and select range "C2:d9" based on the following code:

However, when the compiler gets to that line, I get an error stating "Method 'Range of object'_Worksheet' failed". I'm sure I might be forgetting something, but can not figure out why excel will not select the cell range.

probably best to ask this question in the Excel forum...

nevemind, found the problem...compiler was gettting confused because the code is to work across multiple sheets and couldn't decipher which sheet to run the code on. Once I specified Activesheet.Range(Activecell.offset... ) all was fine.

Hi Mike,

Why not just use this?

I know that would've been the simple solution, but I try not to use absolute ranges in my code if at all possible. I tend to get less errors that way

What makes your code error prone is that it uses ActiveCell etc... which then relies upon particular ranges being selected.

In a general sense, rather than using Offset within Range, Cells is better.
(Not that I'm recommending the Select method attached on the end - I'm concentrating on the Range syntax). This syntax is useful in loops, for example. But there's nothing error prone about the last example I posted.