View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Correct VBA syntax

One way:

ActiveSheet.Cells(rownum, colnum).Activate



In article ,
Ken G. wrote:

What is the correct vba syntax to use to make a particular cell the active
cell when the row number and column number are known?