Get cell value using named range in Excel VBA

Question

I'm doing my first Excel VBA project and am having some trouble. I'd like to get the value in a cell in the CurrentBalance column. I'll be using ActiveCell.Row to get the row number. And I'd like to use a named range for the column in case I need to insert additional columns later.

So what I'd like to have is: BalanceVariable = "CurrentBalance"$ActiveCell.Row

I've been trying things for an hour and can't get it to work. I've tried Range and Cell and othe things. Suggestions?

teylyn · Accepted Answer · 2015-04-28 03:37:53Z

4

CurrentBalance is a named range.

Sub test()
Dim BalanceVariable As Double
BalanceVariable = Cells(ActiveCell.Row, Range("CurrentBalance").Column)
MsgBox "the current balance is " & BalanceVariable

End Sub

enter image description here

answered Apr 28, 2015 at 3:37

teylyn

36.3k6 gold badges58 silver badges76 bronze badges

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

Collectives™ on Stack Overflow

Get cell value using named range in Excel VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related