Thread: selecting cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lance Lance is offline
external usenet poster
 
Posts: 39
Default selecting cells

Hello,

I'm new to VB and VBA.. I was wondering how I might take the active cell I
am currently on in worksheet 1, and go to that same cell in worksheet 2. I
see how to do it if you make it rigid to a specific cell, but how do I make
it take whatever cell I have selected when it's different every time? (..hope
that makes sense)

Thanks,
Lance