Andrew.Noble
New Member
- Joined
- Sep 18, 2011
- Messages
- 6
Hi
I'm trying to determine the number of rows within a named range in an external workbook, to use in my VBA code.
I have tried the following approach but receive an error:
Thanks for any help.
I'm trying to determine the number of rows within a named range in an external workbook, to use in my VBA code.
I have tried the following approach but receive an error:
Code:
Dim rangeRows as Integer
Dim rangeAddress as String
rangeAddress = "'C:\Temp\Book1.xlsx'!NamedRange"
rangeRows = Range(rangeAddress).Rows.Count
Thanks for any help.