Macro to select cells

[floridagunner]

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:

Please Login or Register  to view this content.

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?

[Whizbang]

Get rid of the "(Offset(0, -1)"

Please Login or Register  to view this content.

[floridagunner]

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.

[nimrod]

Maybe upload a sample sheet ;-)

[floridagunner]

How do I upload a sample spreadsheet? I don't see an attachment button.

[nimrod]

click "Go Advanced" then scroll down to "Manage Attachments" command button

[floridagunner]

Ok Sample Speadsheet now added.

[Whizbang]

Try this.

Please Login or Register  to view this content.

[floridagunner]

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.

[nimrod]

Please Login or Register  to view this content.

[floridagunner]

Thank you Nimrod, it worked!!!!