View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Userforms, switching sheets

....this will make it a lot easy/better

with worksheets("sheet1")
.range("A1") = "foo"
.cells(2,1) = .range("A1")
end with

Especially after I asign them variables so I can easily change the name down
the road...
thanks again!