View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] programmernovice@yahoo.com is offline
external usenet poster
 
Posts: 21
Default VB Excel syntax for "offset" statement

Hi, I've been trying without success to figure out how to do this: I
have an OFFSET statement containing a reference to a different sheet,
and I cannot get it to work. It would have to be something like
OFFSET( worksheet3!lines, 5). I cannot write the "worksheet3!lines"
reference in a way that will work. Can someone please point out how to
do this? Many thanks.