View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sency sency is offline
external usenet poster
 
Posts: 4
Default Workbook_SheetSelectionChange in going infinite

I am calling a macro from Workbook_SheetSelectionChange() where in i am using
something like :
lastCol = ws.Range("A1:IV1").cells.SpecialCells(xlLastCell). Column which
goes back to my Workbook_SheetSelectionChange() routine again, effecting an
infinite loop. How can i proceed with this code? How can i stop it from going
back to Workbook_SheetSelectionChange() whenever i make a range selection??

thanks in advance, Sency.