excel vba syntax

• • Reply

  14 years ago

  by kwwm

  karen mcavoy

  , United States

  Joined 14 years ago

  I have the following code.......

  Selection.AutoFill Destination:=Range("E1:E795"), Type:=xlFillDefault

  I would like to substitute a variable named "count",  for the 795. When I try to, I keep getting an error.  Anybody?

  thx---kwwm

  Report abuse
• • Reply

  14 years ago

  by jgiddy

  John Giddy

  , Australia

  Joined 14 years ago
  You don't say what error you are getting. I had a similar problem when trying to use a variable in a Range description.
  The solution in my case was to use (using your example):
  
  Range("E1:E" & count)
  
  You need to use the "&" operator, NOT "+", as the "&" does type conversion without adding any extraneous stuff.
  
  
  
  
  
  
  
  Report abuse
• • Reply

  14 years ago

  by kwwm

  karen mcavoy

  , United States

  Joined 14 years ago

  I did it and it worked---thanks a lot!---kwwm

  Report abuse