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 at the same time with variable and am
getting an error message. I'm sure it is a syntax issue. Following is the
code in question. I'd appreciate any help with resolving this issue. Thanks
for the help.

Range(("A" & frow, "A" & lrow), ("C" & frow, "C" & lrow), ("E" & frow, "F" &
lrow), ("H" & frow, "I" & lrow)).select

frow is a variable I set for the first row of data and lrow is a variable I
set for the last row of data.

Thanks again for all of the help......
--
JT