VBA to Select variable rows across columns

Question

current code is

lngLastRowDPWK = ActiveSheet.Cells(Activesheet.Rows.Count,"DX".End(xlUP).Row+3

Range("DP" & lngLastRowDPWK:"DV" & lngLastRowDPWK +2).select

I'm wanting it to highlight a few rows of in columns DP-DV but the row number is a variable. Any help is appreciated. Thank you

YowE3K · Accepted Answer · 2017-06-04 23:49:39Z

1

Sub test()
    'You were missing a ")"
    lngLastRowDPWK = ActiveSheet.Cells(ActiveSheet.Rows.Count, "DX").End(xlUp).Row + 3
    'You weren't creating the string correctly
    Range("DP" & lngLastRowDPWK & ":DV" & lngLastRowDPWK + 2).Select
End Sub

answered Jun 4, 2017 at 23:49

YowE3K

24k7 gold badges28 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3066795 Over a year ago

Range("DP" & lngLastRowDPWK & ":" & "DV" & lngLastRowDPWK +2).select

user3066795 Over a year ago

Thank you I found that variation as well at the same time. I will use yours in my code though thanks for the help

BruceWayne Over a year ago

@user3066795 - Why are you selecting the data? FYI it's best to avoid using .Select/`.Activate

Collectives™ on Stack Overflow

VBA to Select variable rows across columns

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related