Thread: syntax error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default syntax error

I'm trying to select several ranges using a variable (verylastrow) at the
same time to format the items in the selection but I am having a problem. It
must be Friday because I cannot figure out the syntax error in the following
code:

Range("(A1:A & verylastrow), D1:E & verylastrow), (G1:H &
verylastrow)").Select

I'm sure it is something simple but any help would be appreciated. Thanks.
--
JT