Re: Need Help on Dynamic Range Selection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks everyone for the replies...I could figure it out now...I
apologize for using the "Urgent" header...I was not aware of the
protocols here as I am brand new...:-) Thanks once again for the
codes. Though I could not understand any of the codes, I could somehow
make Leo Heuser's code work. Thanks to all other too!

Cheers,
Anshuman

On Jul 11, 9:08 pm, "Don Guillett" <dguille...@xxxxxxxxxxxxx> wrote:
Right click *** tab>view code>insert this. Now when you select a2, a2:g3
will be selected, etc. But WHY select when it is usually not desirable. Tell
us more.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 And Target.Row Mod 3 = 2 Then
Target.Resize(2, 7).Select
End If
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@xxxxxxxxxxxxx"anshu" <mailanshu...@xxxxxxxxx> wrote in message

news:1184150322.990859.67420@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi All,

I need an urgent help with one of the macros I am working on

Say I am at the cell A2. I need to select the range A2:G3. When I try
to record macro for this, it reads

Range("A2").Select
Range("A2:G2").Select

The Problem is that I dont need the Alphabetic reference as I need to
repeat the step for every 3rd row (A5, A8, A11 etc )..I was trying to
use the RC reference but its not working.

Please help

Thanks in advance


.

Quantcast