Thread: Offset concern
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bri[_3_] Bri[_3_] is offline
external usenet poster
 
Posts: 29
Default Offset concern

I'm having trouble modifying a line of code. As shown the code selects the
data in columns A:C from row 2 down the the last row with data in A. This
work fine.

Worksheets("Sheet1").Range("A2:C" & Range("A2").End(xlDown).Row).Select

Here's my problem. I need to keep offsetting this calculation by 4 columns
using an integer n. If n=1, the code is as above. If n=2, the code should
select the data in columns E:G from row 2 down the the last row with data in
E (that very last part about E is where I'm stuck).

I'd be grateful for help with this
Bri