View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] oldyork90@yahoo.com is offline
external usenet poster
 
Posts: 59
Default table column name with newline, cannot select with string

I have a 2010 excel table where a column name contains a newline.

While I can access this column using an index number I can't using a string.

I've tried

s = "Rotor" & vbnewline
s = "Rotor" & chr(13)

Is this possible or must the newline be remove. This newline was created
with the keycombo Alt-Enter

Fails:
ListObject.ListColumns(s).Index

Thank you