View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lonnie M. Lonnie M. is offline
external usenet poster
 
Posts: 184
Default Updating Worksheet Through User Form

Correction: Not ActiveSheet.Name...

Workbooks.Open Filename:=myFileNameDir, UpdateLinks:=0
Set ws = ActiveSheet