Thread: Offset with variable?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default Offset with variable?
st1 is an object and therefore must be set...
Set st1 = st1.Offset(1,0)

HTH

Die_Another_Day
John wrote:
I get an error on this simple line of code...

st1 = st1.Offset(1, 0)

st1 is a range... is there anyother way to make st1 step one cell down?

Reply With QuoteReply With Quote