How to write an Excel macro to select a group of cells?

Question

How to write an Excel macro to select a group of cells?

I'm looking for a macro that can be run to select a consistent range of cells so that I can easily copy them to another table. The range would be F3: BJ3.

+1

vba excel-vba select excel range

nlh Dec 10. '08 at 19:52

source to share

2 answers

e.James · Answer 1 · 2008-12-10T19:56:14+0000

This should do the trick:

Public Sub selectCells()
    Range("F3:BJ3").Select
End Sub

edit:, for this you can use the following to execute the "copy" command:

Public Sub selectCellsAndCopy()
    Range("F3:BJ3").Select
    Selection.Copy
End Sub

Lalit bhudiya · Answer 2 · 2012-04-02T07:48:03+0000

Use this one, it works fine.

Sub On_Click()
    ActiveSheet.Range("A1:E1").Select
End Sub

How to write an Excel macro to select a group of cells?

More articles: