Using ISREF with closed workbooks

User avatar
Doc.AElstein
BronzeLounger
Posts: 1499
Joined: 28 Feb 2015, 13:11
Location: Hof, Bayern, Germany

Re: Using ISREF with closed workbooks

Post by Doc.AElstein »

YasserKhalil wrote: using this line in the code ThisWorkbook.Worksheets.Item(1).Evaluate("ISREF('[" & ws.Name & "'!A1)") Then throws aerror
you had a typo....Evaluate("ISREF('[" & ws.Name & "'!A1)") Then
Last edited by Doc.AElstein on 22 Feb 2019, 15:00, edited 3 times in total.
I am having difficulty logging in with this account just now.
You can find me at DocAElstein also
Top
YasserKhalil
PlatinumLounger
Posts: 4936
Joined: 31 Aug 2016, 09:02

Re: Using ISREF with closed workbooks

Post by YasserKhalil »

Yes I got it.I was wrong at this part
Thank you very much
Top

Return to “VB/VBA/.Net/Office Scripting”