View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
neopolitan neopolitan is offline
external usenet poster
 
Posts: 1
Default code to change activecell

I am using a macro to input four different formulas into adjacent cells
(Ex: C2,D2,E2,F2). These cells will not always be the same depending
on the worksheet that is being acted on. I don't know how to move
right one column in the same row in VBA code using the previous active
cell as a reference point. Can someone give me a simple VBA expression
to do this? Thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/