Attached is a sample worksheet that includes two scripts. One of the scripts is for the Worksheet("Dictionary") and the other is a sort routine in its own Module.
Something (apparently unrelated to the range setting) in the "Worksheet(Dictionary") sheet is preventing the sort from including the first row of data in the sort routine. Whatever it is is also preventing me from cutting a row and pasting it to the end of the data rows.
As strange as it sounds (to me anyway), the problem appears to be in the temporary formatting that is applied to the range of data to highlight the cells for the active row. The reason I suggest this is that I can copy the data to another sheet, remove all the formatting and the sort seems to work fine.
Can someone please help me identify what it is causing the behavior described above?
Thanks,
Opv
Reply With Quote