VBA - select range dynamically

[wibni]

Hi,
In Excel 2003, how can I change my range dynamically?
I want colum D to increase by 5 for every one of my loops.

FR = Range("C1:D" & LR).Find("RigSite", , xlValues, xlWhole, xlByRows, xlNext, False).Row

 

[wibni]

This seems to do the trick.

FR = Range("C1:" & Cells(LR, 4).Address).Find("RigSite", , xlValues, xlWhole, xlByRows, xlNext, False).Row

 

[Rick Rothstein]

Hi,
In Excel 2003, how can I change my range dynamically?
I want colum D to increase by 5 for every one of my loops.

FR = Range("C1:D" & LR).Find("RigSite", , xlValues, xlWhole, xlByRows, xlNext, False).Row

I would be interested in knowing what it is that you are doing that made you asked this question.