Thread: VBA: How to specify 2nd cell of currently active row?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich Rich is offline
external usenet poster
  
Posts: 298
Default VBA: How to specify 2nd cell of currently active row?
In a macro, I want to be able to set the value of the second cell of the
currently active row. How can I calculate the correct range or offset to do
this? For example, if the currently active cell is An, I want to set A2 to a
specific value.

Thanks,

Rich
Reply With QuoteReply With Quote