Using variables in Excel range

Question

I am looking to use variables to find a range as well as then use those to activate a selection.

Here is the code I have:

Dim first As Integer
Dim Last As Integer

first = (ActiveCell.Row + 1)
Selection.End(xlDown).Select
Last = (ActiveCell.Row - 1)
Range(("J" & first) : ("J" & last)).Select

However, I am getting a syntax error on this in Excel VBA 2010.

Any suggestions.

Thanks,

DanB · Accepted Answer · 2014-01-17 00:06:17Z

1

The Range syntax is Range("A1:B2") so you will need to modify your code to:

Dim first As Integer
Dim Last As Integer

first = (ActiveCell.Row + 1)
Selection.End(xlDown).Select
Last = (ActiveCell.Row - 1)
Range("J" & first & ":" & "J" & Last).Select

answered Jan 17, 2014 at 0:06

DanB

263 bronze badges

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

1 Comment

SASUSMC Over a year ago

Thanks. Works perfect. Next part is how to use that in formula- posting on that now.

Collectives™ on Stack Overflow

Using variables in Excel range

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related