Using Named Range in VBA

[ManUBlueJay]

I have a named Range called "MyRange" that is not associated to a cell but is a calculation counting how many rows are used.
I would like to have a message box at the end of my code to tell me how many records were effected.

I did the following but it returns a Run Time Error 1004 on "LineCount = Range("MyRange").Value" line

Sub MyMacro()

Dim LineCount As String
LineCount = Range("MyRange").Value

Range("Import_DataBaseRange") = Range("Import_UpdateRange").Value

MsgBox ((LineCount) & " Records Have Been Added")
ActiveWorkbook.Save
End Sub

 

[Fluff]

How about

linecount = [MyRange]

 

[ManUBlueJay]

I have already tried that without success. I have never managed if my named range is not associated to a cell. I am sure there is a simple way

 

[Fluff]

What is the formula you are using in the name?

 

[mikerickson]

This worked for me

linecount = Evaluate("=MyRange")

 

[ManUBlueJay]

Perfect
Thank you
Would that work for other applications like Range ("A1")= Evaluate("MyRange")

 

[Fluff]

What happens if you try?

 

[ManUBlueJay]

Stunning!! That was not just "fluff". Thank you for providing with a little bit of further education