View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dirk Nachbar Dirk Nachbar is offline
external usenet poster
 
Posts: 11
Default inputbox syntax location

pcnt is a string, put val() around it

ActiveWindow.SelectedSheets.PrintOut Copies:=val(pCnt), Collate:=True

Dirk