Need Help on Dynamic Range Selection

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

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

.

Relevant Pages

  • Re: Need Help on Dynamic Range Selection
    ... I need an urgent help with one of the macros I am working on ... Dim CollectRange As Range ... Dim Counter As Long ...
    (microsoft.public.excel.misc)
  • Re: Need Help on Dynamic Range Selection
    ... Right click sheet tab>view code>insert this. ... I need an urgent help with one of the macros I am working on ... to record macro for this, ... The Problem is that I dont need the Alphabetic reference as I need to ...
    (microsoft.public.excel.misc)
  • Re: Desperate help! Copying modules renames them!
    ... > Hi - I am having a very annoying problem and need some urgent help on it - ... > I wrote some macros that fire in Microsoft Project - to check if the user ... copying the updated modules into the current ... > rename the module via code. ...
    (microsoft.public.project.vba)
  • Re: Desperate help! Copying modules renames them!
    ... > Hi - I am having a very annoying problem and need some urgent help on it - ... > I wrote some macros that fire in Microsoft Project - to check if the user ... copying the updated modules into the current ... > rename the module via code. ...
    (microsoft.public.office.developer.vba)