Notifications
Clear all
Topic starter
I've a defined name "upperbound" referring to "=COUNTA(IdList[Path]) " to count the number of rows in the column "IdList[Path]", Then I tried to assign the value of "upperbound" to cell A1 using the VBA code as follows:
Sub test()
Range("A1").Value = upperbound
Range("A1").Value = upperbound
End Sub
unfortunately it didn't work as I expected. How should I fix it? Thanks.
Posted : 16/10/2017 3:57 pm
Hi Julian
Maybe you can give this a try.
Range("A1") = Application.Evaluate("upperbound")
Sunny
Posted : 16/10/2017 9:19 pm
Topic starter
Hi Sunny,
Yes, it solved my problem. Thank you again.
Julian
Posted : 18/10/2017 5:20 am