Macro to select cells

Hello All,

I am trying to write a Macro that will automatically select a range of cells. The macro I am using is as follows:

    Sheets("Pivot Table").Select
    Rows("3:3").Select
    Selection.Find(What:="Period").Select
    Selection.Select
    ActiveCell.Offset(1, 0).Select
    Range(Selection, Selection.End(xlToRight)).Offset(0, -1).Select

In my particular worksheet the value "Period" is on cell C3. So the Macro should select cells C4:T4. However when I run the Macro it actuall selects cells B4:T4

Does anybody know what the mistake in this code is?

Hello Whizbang,

I just used your code, with the "(Offset(0, -1)" ommitted. However now the macro is selecting the cells C4:U4, when I need it to select C4:T4, which is one column less than the last column with data.

Hope I'm being clear.

Hello Whizbang,

That code did not work as it selected everything to the right of cell C4 including cell C4. The actual cells selected were C4:IU4.

What I need it do is select cells C4:T4, and not the Grand Total column or anything to the right of the Grand Total column.