syntax error
JT wrote:
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......
":" not ,
"A" & frow & ":A" & lrow
|