vba calculate first row of named range

Euro5
Euro5 used Ask the Experts™
on
I have a named range, the first column I need to change the values in first row of the range.
The before & after is below:
OZ.JPGOZ-new-weight.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try this...

    Dim i As Long
    With Range("NamedRange")
        For i = 2 To .Rows.Count - 1
            .Cells(i, 1) = .Cells(i, 1) * 0.0625
        Next
    End With

Open in new window

Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
This is simpler. nr is the name of the named range.
Range("nr").Row

Author

Commented:
Thank you!!
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
@Euro5: I'm surprised you'd rather loop through a group of rows then get the value immediately, but of course it's your choice.
Get what value Martin? Even now, I can't see any requirement of a value being returned.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Well the question title contained "calculate first row of named range" and I assumed that the author wanted to find out the row number of the first row in a named range.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial