Thread: Relative Refs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default Relative Refs



Hi there,

Using VB, I want to tell Excel to got cell b10, which is easy enough
(Application.Goto Reference:="R10C2") ! but I then want to tell it to
move ONE cell down (One cell down is not B11 as its a filtered list so
next cell will change depending on results of filter...

Thanks!!!

Regards

Darin

*** Sent via Developersdex http://www.developersdex.com ***