Thread: VBA Question
View Single Post
  #36   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl carl is offline
external usenet poster
 
Posts: 42
Default VBA Question

On Jun 30, 2:23*pm, Gord Dibben wrote:
I meant backslash "at the end"



On Thu, 30 Jun 2011 11:21:16 -0700, Gord Dibben wrote:
Isabelle


It doesn't matter whether the backslash is present or not.


Works either way for me.............what is critical are the double quotes.


Gord


On Thu, 30 Jun 2011 13:16:06 -0400, isabelle wrote:


is that list contains values like "c:\temp\" with a backslash in the end ?- Hide quoted text -


- Show quoted text -


Thanks all. I've worked through this intital issue. Now the results
display #REF1.

Can you confirm that this will work on an XLSX file - I am running
Excel 2003.