Thread: Serial Number start and end range auto-fill into cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
  
Posts: 621
Default Put Prefix in cell A1, Start Serial Number in B1, end Serial Number in C1.
Make that space then underscore.

Range("C"& RowCount) =<spaceunderscore


Merry Xmas, Gord

On Wed, 29 Dec 2010 10:37:03 -0600, Dave Peterson
wrote:

The physical line should actually end with an underscore followed by a space
character.
Reply With QuoteReply With Quote