Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Header concern | Excel Programming | |||
Page Header concern | Excel Worksheet Functions | |||
sorting concern | Excel Worksheet Functions | |||
hidden column concern | Excel Worksheet Functions | |||
Toggle Button Updating Concern | Excel Programming |