View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Lostguy Lostguy is offline
external usenet poster
 
Posts: 15
Default a) char(10) and b) asterisks for borders?

All,

Thanks!

Rick: I tried ="a"&String(2, vbLf)&"b", ="a"&String(2, CHAR(10))&"b",
and ="a"&String(2, 10)&"b" and all produce the #name? error.

??

Gord: Perfect! Your idea chopped 1-3K off of my file sizes! (which is
what I was trying to do). I had been using rows and columns of cells
that were blue-colored to make a frame. With your method, I was able
to delete those. Thanks!

VR/

John