View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Sometimes data will jump rows randomly.

Your spreadsheet may have a macro that performs a row insert when a
particular spreadsheet event occurs. It may be set up to occur when
you enter or leave a particular cell or particular range of cells, or
when a certain cell is a certain value, or some other condition is
true, for instance.

You can check this by pressing ALT-F11 to open the VBA editor. In the
Project pane along the left margin of your screen, find the VBAProject
associated with your spreadsheet name. There is an icon tree for each
tab in the workbook, and for the workbook: right click on each icon and
click View Code- this is where event macros are stored. The event
triggers will be called something like SelectionChange, Change,
Deactivate, etc. Look for the command Insert, and investigate the
source and rationale for that macro.