Hi,
thanks for your time.

anyways, i solved this by moving the macro call from
Workbook_SheetSelectionChange() to Worksheet_SelectionChange().

"sency" wrote:

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.