Macro To Select variable range

**dubiic** · 04-14-2008, 09:36 AM

Hello!

I would like to create macro which is doing following. Selects for example C3 cell then does shift+cntrl+down (xlDown, if i understand right) and then counts off last 3 rows.
So I get whole rows in C column except last 3 ones. And i can format them further.

as I understand i have to make some kind of variable and use something like

Set x = C3.End(xlDown)

but i have not a single idea about syntax and such things, I am newbie in VB code.

Any help would be realy appreciated.
Thank You!

**royUK** · 04-14-2008, 10:51 AM

You don't need to select a range to work with it. Try

Option Explicit

Sub varRange()
    Dim rng    As Range

    Set rng = Range(Cells(3, 3), Cells(Rows.Count, 3).End(xlUp))
    Set rng = rng.Resize(rng.Rows.Count - 3, rng.Columns.Count)
    MsgBox rng.Address
End Sub

Macro To Select variable range

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro To Select variable range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions